Excel 2003 if it matters.
I have something very basic I want to do:
Formulas for a column. In cell A3 I have:
=IF($C$1-$C$3>=30, "something", "else")
This works fine. The values in C1 and C3 are both dates.
But now what I want to do is apply a formula like this to all cells in column A. Always comparing C1 to CX. So ...
=IF($C$1-$C$3>=30, "something", "else")
=IF($C$1-$C$4>=30, "something", "else")
=IF($C$1-$C$5>=30, "something", "else")
=IF($C$1-$C$6>=30, "something", "else")
=IF($C$1-$C$7>=30, "something", "else")
=IF($C$1-$C$8>=30, "something", "else")
etc etc.
I'll probably add in a couple of ELSE IFs in there, but - I can't get it to apply the formula automatically to column A - It always uses
=IF($C$1-$C$3>=30, "something", "else")
The second cell never changes; I thought it would work just by clicking in the bottom right dot of cell A3 and dragging down.
Selecting C3 and C4 and doing the above makes it alternate between 3 and 4 for the whole column.
Sorry if this makes no sense, but I'm hoping it does.
Just has to always look at C1 for the first value in the calculation, then C<whatever> for the corresponding cell A<whatever>
I have something very basic I want to do:
Formulas for a column. In cell A3 I have:
=IF($C$1-$C$3>=30, "something", "else")
This works fine. The values in C1 and C3 are both dates.
But now what I want to do is apply a formula like this to all cells in column A. Always comparing C1 to CX. So ...
=IF($C$1-$C$3>=30, "something", "else")
=IF($C$1-$C$4>=30, "something", "else")
=IF($C$1-$C$5>=30, "something", "else")
=IF($C$1-$C$6>=30, "something", "else")
=IF($C$1-$C$7>=30, "something", "else")
=IF($C$1-$C$8>=30, "something", "else")
etc etc.
I'll probably add in a couple of ELSE IFs in there, but - I can't get it to apply the formula automatically to column A - It always uses
=IF($C$1-$C$3>=30, "something", "else")
The second cell never changes; I thought it would work just by clicking in the bottom right dot of cell A3 and dragging down.
Selecting C3 and C4 and doing the above makes it alternate between 3 and 4 for the whole column.
Sorry if this makes no sense, but I'm hoping it does.
Just has to always look at C1 for the first value in the calculation, then C<whatever> for the corresponding cell A<whatever>
