Using the autofill function but increment by certain number in function

R

rishid

Hi,
I am using the cumulative payment function
CUMPRINC(rate,nper,pv,start_period,end_period,type)

I cannot figure out how to beable to use the autofill by dragging dow
and increment the 1,12 numbers by 12 each time, so each cell is tota
towards payment each year

For instance
=-(CUMPRINC(D$42/12,D$43*12,D$41,1,12,0))
=-(CUMPRINC(D$42/12,D$43*12,D$41,13,24,0))
=-(CUMPRINC(D$42/12,D$43*12,D$41,25,36,0))
And so on....


Thanks
 
B

Bernie Deitrick

Entered into cell G3, for example:

=-(CUMPRINC(D$42/12,D$43*12,D$41,1+(ROW()-ROW($G$3))*12,(ROW()-ROW($G$2))*12,0))

Note that you need to change the $G$3 to the cell address where the formula is entered, and the $G$2
to the cell above that cell.

HTH,
Bernie
MS Excel MVP
 
Top