Excel Formula to get "OKAY' between 2 sets of tolerances

[MelissaOsborne]

I need an Excel formula that checks for value between 2 seperate ranges. Check if value is between (.0406 and .0483) or between values (-.0483 and -.0406). Either value is OK in the Same Cell

I tried and if statement. This one Didnt work however.

This is what I have. However the code only checks to make sure all the statements are true instead of checking between 2 sets of values.

=IF(AND(AQ135>=0.0406,AQ135<=0.0483,AQ135<=-0.0406,AQ135>=-.0483),"OK","")

The formula should say OK in the cell after it verifies that the cell AQ135 is either between (.0406 and .0483) or (-.0406 and -.0483). The value can not equal outside of these 2 ranges.

 

[Cubist]

Try:

=IF(AND(ABS(AQ135)>=0.0406,ABS(AQ135)<=0.0483),"OK","")

 

[MelissaOsborne]

Try:

=IF(AND(ABS(AQ135)>=0.0406,ABS(AQ135)<=0.0483),"OK","")

Oh My Gosh!! Thank you so much. I was trying to use ABS but I had entered it incorrectly. Thank you for teaching and helping me us it!