Copying IF formulas

[Davidm]

I want to use a "IF" formula on one worksheet to look in column A1 and put
the result of column B1 as a result, if A1 = 1, then be able to copy this
formula across so it still looks to column A1 and puts in C1 if A1=1. I can
do this by making A1 an abosolute reference but then this formula wont copy
down so that the next row looks at A2 is there a way of doing this with a
"IF" formula or should I be using something else?

Regards Davidm

 

[akphidelt]

You should be able to do this with just a $ sign in front of the A

like =$A1 instead of $A$1

 

[Davidm]

Thanks that was what I Needed

You should be able to do this with just a $ sign in front of the A

like =$A1 instead of $A$1