Using the autofill function but increment by certain number in function
 

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 down
and increment the 1,12 numbers by 12 each time, so each cell is total
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.


--
rishid
------------------------------------------------------------------------
rishid's Profile: http://www.excelforum.com/member.php...o&userid=18486
View this thread: http://www.excelforum.com/showthread...hreadid=387265

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


"rishid" wrote in message
...

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 down
and increment the 1,12 numbers by 12 each time, so each cell is total
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.


--
rishid
------------------------------------------------------------------------
rishid's Profile: http://www.excelforum.com/member.php...o&userid=18486
View this thread: http://www.excelforum.com/showthread...hreadid=387265