Copying IF formulas


D

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
 
Ad

Advertisements

A

akphidelt

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

like =$A1 instead of $A$1
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top