CUMIPMT(rate,nper,pv,start_period,end_period,type)
CUMIPMT returns the cumulative interest paid on a loan between start_period and end_period.
-
If rate <= 0, CUMIPMT returns #NUM! error.
-
If nper <= 0, CUMIPMT returns #NUM! error.
-
If pv <= 0, CUMIPMT returns #NUM! error.
-
If start_period < 1, CUMIPMT returns #NUM! error.
-
If end_period < start_period, CUMIPMT returns #NUM! error.
-
If end_period > nper, CUMIPMT returns #NUM! error.
-
If type <> 0 and type <> 1, CUMIPMT returns #NUM! error.