Join to IF Statements referring to percentages

[tlc53]

Hi there,

I can't work out why I can't join these two IF Statements. Separately, they work fine.

=IF(J40<3.5%,"Acceptable Variance (Does not exceed 3%)","Unacceptable Variance! (Exceeds 3%)")
=IF(J40>-3.5%,"Acceptable Variance (Does not exceed 3%)","Unacceptable Variance! (Exceeds 3%)")

But if I join them together;
=IF(OR(J40<3.5%,J40>-3.5%),"Acceptable Variance (Does not exceed 3%)","Unacceptable Variance! (Exceeds 3%)"))

It doesn't work. I want to capture when it exceeds +/- 3.5%

Can anyone see where I am going wrong?

Thanks!

 

[Fazza]

try less than for the negative value instead of greater than

alternatively re-write using ABS

 

[tlc53]

try less than for the negative value instead of greater than

alternatively re-write using ABS

ABS did the trick. Thank you!

 

[Fazza]

you're welcome

the greater than -3.5% didn't work cause you want less than -3.5%
the number scale increases from -10% to -3.5% to 0% to 10%
-10% & -5% are less than -3.5%
2% and 4% are greater than -3.5%