IF function

[davegriffin44]

simple one this but my minds gone blank....

I need to use the IF function to select a different return with different ranges, EG:

If cell A1 is between 120-135 give me cell A2
If cell A1 is between 105-120 give me cell A2

Etc..
?

Thanks

 

[VBACO]

I am sure there is a better way but...

=IF(AND(A1>104,A1<121),A2)