| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cannot get CUMIPMT to work in Excel
Using formula =CUMIPMT(0.0075,360,125000,1,1,0)
Analysis toopak is installed. Please Help!! Norbert :) -- Work is good, but it's not that important. |
|
#2
|
|||
|
|||
|
Norbert J wrote...
Using formula =CUMIPMT(0.0075,360,125000,1,1,0) Analysis toopak is installed. Please Help!! What result are you getting? A #NAME? error? A wrong number? |
|
#3
|
|||
|
|||
|
What result are you expecting? What are you getting? "Can't get it to work"
could mean a lot of things. Result should be -937.50 (1st month's interest on 125,000 loan @ 9% APR) -- George Nicholson Remove 'Junk' from return address. "Norbert J" wrote in message ... Using formula =CUMIPMT(0.0075,360,125000,1,1,0) Analysis toopak is installed. Please Help!! Norbert :) -- Work is good, but it's not that important. |
|
#4
|
|||
|
|||
|
Hi
The correct ans is -937.50 I am getting a # Ref! Thank you for your prompt reply Norbert "George Nicholson" wrote in message ... What result are you expecting? What are you getting? "Can't get it to work" could mean a lot of things. Result should be -937.50 (1st month's interest on 125,000 loan @ 9% APR) -- George Nicholson Remove 'Junk' from return address. "Norbert J" wrote in message ... Using formula =CUMIPMT(0.0075,360,125000,1,1,0) Analysis toopak is installed. Please Help!! Norbert :) -- Work is good, but it's not that important. |
|
#5
|
|||
|
|||
|
On Fri, 17 Jun 2005 14:29:46 -0700, "Norbert J"
wrote: Using formula =CUMIPMT(0.0075,360,125000,1,1,0) Analysis toopak is installed. Please Help!! Your formula, when pasted into my worksheet, gives an answer of -937.50. Is that really the formula you have from your worksheet? --ron |
|
#6
|
|||
|
|||
|
"Norbert J" wrote...
The correct ans is -937.50 I am getting a # Ref! Thank you for your prompt reply .... If you're truly getting a #REF! error from the formula =CUMIPMT(0.0075,360,125000,1,1,0) [note: all numeric constants], then the only thing I can think of is that CUMIPMT is used as a defined names with a definition that evaluates to #REF! Is the formula above your *ACTUAL* formula, or is your actual formula using cell references for some arguments but you figured you'd simplify it when posting to the newsgroup? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I link excel spreadsheets that work on other computers | Excel Discussion (Misc queries) | |||
| C++ dll in Excel 97 does not work in Excel 2003 | Excel Discussion (Misc queries) | |||
| How can I make Excel Macros created on PC work on Macintosh? | Excel Worksheet Functions | |||
| Does SQL.REQUEST work in Excel X? | Excel Discussion (Misc queries) | |||
| Does Microsoft Excel work with XP | Excel Discussion (Misc queries) | |||
Linear Mode
