| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
"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? |
| 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) | |||
Threaded Mode
