|
|
 |
| Author |
|
Message |
|
|
|
Lesson 1
Posted: Aug. 30
Don,
I am hung up on the exercise problem on part 7 of the 1st lesson (which involves "Int-Practice1")
the instructions are very simple,but I am totally out of the picture on making anything work like the example shows that it should.
What setting is supposed to be in the number format?
When I enter the formulas into the E 2,3,4, columns all I get is zero's in the column.
I have spent about 5 hours on this in the last 3 days and I know that it is something simple that I am overlooking.
I'm using MS Office Home and Student 2007 on XP Pro sp3, are there features that are not avaiable on this version.
Thanks in advance
Mike Mulligan
|
|
|
|
Re: Lesson 1
Posted: Aug. 30
Hi Mike,
For the purposes of the material in this lesson, all the features are available in your configuration.
What formulas exactly are you entering in E2-E4?
Are you sure you've set up the range names correctly?
Don
|
|
|
|
Re: Lesson 1
Posted: Aug. 31
As I figured it was something simple.
When I was entering the names in the NAME box, I was not "enter"ing and when I was typing the range names, I was "not" doing the same thing.
The range names had been typed correctly, but not entered corectly.
Geez, what a maroon
Some words in instructions just can't be skimmed over.
Thanks for the assist, Don.
|
|
|
|
Re: Lesson 1
Posted: Aug. 31
Mike,
Please don't beat up on yourself too much. For the kind of software it is, Excel can be remarkably tolerant of human foibles in some cases.
But in others, it's worse than your 7th grade algebra teacher -- old, bitter, and utterly intolerant.
You just ran into the other one. Welcome to 7th-grade Algebra. }:-)
Learn from this, to take every instruction as gospel necessity. When you find an apparent short cut, be aware that while it may work in this case, it probably won't in different circumstances.
Always play it by the book, and while other Excel wizards may consider you a fuddy-duddy, Excel will never let you down.
Don
|
|
|
|
Re: Lesson 1
Posted: Oct. 5
(Edited Oct. 5)
Hi. Don
Question: Lesson 1
Create an amortization table
To complete this assignment:
I have a problem with In cell B10, enter =ABS(PMT(Rate,Length,Amount)).I get the ##### and i don't know how to fix it can you please give me some help with it, other then that i was doing just fine.The way inwhich the formula is expressed on the asignment will not calculate correctly? Ihave tried a few different ways but it still does not work
Thanks
In Advance
thills3848
|
|
|
|
Re: Lesson 1
Posted: Oct. 5
Hi Thills,
The ##### error generally indicates the contents of the cell are too wide to fit the cell. So up at the top of the grid, go to the dividing line between the column which contains the cell with the problem and the column to the right of it. Position the cursor over the line until it changes to a two-headed arrow. Left click and drag the line to the right until the error indicator disappears and is replaced by the cell contents.
Hope that helps, but if that doesn't work, please let me know.
Don
|
|
|
|
Re: Lesson 1
Posted: Oct. 6
(Edited Oct. 6)
I'm stuck here: Assignment: Create an amortization table!
Thanks Don. But this formula does not work the way in which the lesson has it written.=ABS(PMT(Rate,Length,Amount)).This is my problem i got to B10 where it states in the Asignment to. But it's not working for me.?
Thank again
Don
thills3848
|
|
|
|
Re: Lesson 1
Posted: Oct. 6
Don this is what i keep getting: #VALUE!
Using the Asignment formula= =ABS(PMT(Rate,Length,Amount))
Look below all so at the
Loan Amortization
Annual Interest Rate: 6.00%
Monthly Interest Rate: 0.50%
Recurring Extra Payment: $0.00
Starting Balance of Loan: $200.000.00
Length of Loan: 360
# Payment Date Principal Interest One-Time Regular Balance
1 #VALUE! $0.00 $0.00 $0.00 $0.00
2 $0.00
3 $0.00
4 $0.00
In cell B10, enter =ABS(PMT(Rate,Length,Amount)). Copy that function to the range B11:B369.
In cell C10, enter the first day of next month. (For example, if it's now October 15, 2007, enter 11/01/07.)
I won't to understand what i'm doing wrong?
Thanks Don
thills3848
|
|
|
|
Re: Lesson 1
Posted: Oct. 6
Hi Thills,
The #VALUE! error in this exercise is most often generated by using a range name that hasn't been assigned to a cell or range of cells.
Here's how you check for that:
Click on D4 and look in the name box in the upper left corner just above the column labels, and you should see the word, "Rate" (without the quotation marks).
Next, click on D6 and the name box should read Amount.
Finally, click on D7 and the name box should read Length.
That's telling you that each of the three cells is a range, and the range has a specific name.
Excel doesn't do that by itself; you have to create the named ranges. If you aren't sure how to do it, please review the material on page 7 of Lesson 1.
If that doesn't work or you still have questions, please let me know.
Thanks!
Don
|
|
|
|
Re: Lesson 1
Posted: Oct. 7
Thans Don I finaly figured out that i needed to widen the columb some. So simple! but thanks again.
T Hills
|
|
Printable version