Problem with dragging formula down a column
 

Let' take a simple example:
PRINCIPLE: (cell C3)
INTEREST RATE: (cell D3)

YEAR 1: =SUM(C3+((C3*D3)/100))

OK, everything is fine. Drag it down by itself at you get

=SUM(C4+((C4*D4)/100))

Now you have to go back and change the 4 to a 3.

I have something far more complicated than this. The central problem is the
drag down. I tried holding down the option key but that gives funky results.

Problem with dragging formula down a column
 

If you want to continuously reference C3 you could change the reference to
$C$3. Does that help?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.

"GLM" wrote:

Let' take a simple example:
PRINCIPLE: (cell C3)
INTEREST RATE: (cell D3)

YEAR 1: =SUM(C3+((C3*D3)/100))

OK, everything is fine. Drag it down by itself at you get

=SUM(C4+((C4*D4)/100))

Now you have to go back and change the 4 to a 3.

I have something far more complicated than this. The central problem is the
drag down. I tried holding down the option key but that gives funky results.

Problem with dragging formula down a column
 

Thanks,

that was it.

GLM

"Barb Reinhardt" wrote:

If you want to continuously reference C3 you could change the reference to
$C$3. Does that help?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.

"GLM" wrote:

Let' take a simple example:
PRINCIPLE: (cell C3)
INTEREST RATE: (cell D3)

YEAR 1: =SUM(C3+((C3*D3)/100))

OK, everything is fine. Drag it down by itself at you get

=SUM(C4+((C4*D4)/100))

Now you have to go back and change the 4 to a 3.

I have something far more complicated than this. The central problem is the
drag down. I tried holding down the option key but that gives funky results.