Maybe it's late and this is a simple answer, but I'm stumped.

In cell C3, I have the formual {=IF('Test Cycle Tracker'!N3="R", C2, 0)}. I
want to drag this down the cell rows, keeping C2 as a constant. I can't seem
to get it to not change, even with the Ctrl key.

Do I have to go in and do a manual change to each cell, or is my brain locked?
Help! Thanks.

On Nov 14, 1:43 pm, KJG wrote:
Maybe it's late and this is a simple answer, but I'm stumped.

In cell C3, I have the formual {=IF('Test Cycle Tracker'!N3="R", C2, 0)}. I
want to drag this down the cell rows, keeping C2 as a constant. I can't seem
to get it to not change, even with the Ctrl key.

Do I have to go in and do a manual change to each cell, or is my brain locked?
Help! Thanks.


Have you tried this already:
{=IF('Test Cycle Tracker'!N3="R", $C$2, 0)}

hth

Carlo

=IF('Test Cycle Tracker'!N3="R", $C$2, 0)

On Tue, 13 Nov 2007 20:43:00 -0800, KJG wrote:

Maybe it's late and this is a simple answer, but I'm stumped.

In cell C3, I have the formual {=IF('Test Cycle Tracker'!N3="R", C2, 0)}. I
want to drag this down the cell rows, keeping C2 as a constant. I can't seem
to get it to not change, even with the Ctrl key.

Do I have to go in and do a manual change to each cell, or is my brain locked?
Help! Thanks.

Try absolute addressing. $C$2 makes it constant.
$C2 makes the column constant and row changes as dragged down.
C$2 makes the row constant and the column changes as dragged across.

Regards,

OssieMac

"KJG" wrote:

Maybe it's late and this is a simple answer, but I'm stumped.

In cell C3, I have the formual {=IF('Test Cycle Tracker'!N3="R", C2, 0)}. I
want to drag this down the cell rows, keeping C2 as a constant. I can't seem
to get it to not change, even with the Ctrl key.

Do I have to go in and do a manual change to each cell, or is my brain locked?
Help! Thanks.