Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel function cumipmt
This function does not recognize a cell referrence (or a number directly
input) for the second input, number of periods. Instead it returns #N/A. |
#2
|
|||
|
|||
I think you are forgetting the last argument.
Rate / Nper / Pv / Start_period / End_Period / Type If you're using the wizard, there is a 5th argument that you must tab down to. Type... 0 = Payment at the end of the period 1 = payment at the start of the period. =CUMIPMT(0.09/12,30*12,125000,13,24,0) returns -11,135.23 HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Computer Bob" wrote: This function does not recognize a cell referrence (or a number directly input) for the second input, number of periods. Instead it returns #N/A. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling a new function Excel gives me #NAME? | Excel Worksheet Functions | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |