I'm trying to use CUMIPMT in Excel X under Tiger and getting a #N/A
error. What does this mean? There's nothing in the help files about
this error.
I get this only when I don't include all the required arguments. With
many of the financial functions, the type argument is optional. This
isn't the case for CUMIPMT.
You didn't give any numbers, but when I use the following (with type set
for the end of period, or 0):
A1: 6% <=== Annual Rate
A2: $100,000 <=== Present Value
A3: 30 <=== Number of Years
A4: 1 <=== Starting Period
A5: 2 <=== Ending Period
A6: =CUMIPMT(A1/12, A3*12, A2, A4, A5, 0)
returns
-$999.50
does that work for you?
