Using the autofill function but increment by certain number in function

[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 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.

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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


"rishid" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>