1

Can someone please help?

I am using the IF function to find cells within certain ranges, but want the cell to contain the value if it falls within that specific range.

for example: =IF (AA3 is between 150 and 400 then AD3 is equal to AA3 and if not leave blank)

my current formula below does not work: =IF(AND(AA3>150, AA3<400), AD3=AA3, "" )

where AD3 is the cell I am working in...

any suggestions?

1 Answer 1

2

This is the formula for cell AD3:

=IF(AND(aA3>150, aA3<400), aA3, "" )

With spreadsheets, the value that ends up in the cell is either part of the IF, the true or false. There is no need to assign the value to the cell, it is the result of the formula.

1
  • make sure if you want 150 and 400 to be included in the possible values between 150-400 that you change it to >=150 and <=400
    – datatoo
    Jun 28, 2012 at 3:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .