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

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

like =$A1 instead of $A$1

"Davidm" wrote:

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

Thanks that was what I Needed

"akphidelt" wrote:

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

like =$A1 instead of $A$1

"Davidm" wrote:

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