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...