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