IF function that refers to another cell if true
- by geoconfusion
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(AA3150, AA3<400), AD3=AA3, "" )
where AD3 is the cell I am working in...
any suggestions?
