Clever-Excel-Forum

0,02% In Tolerance

-0,53% Not Intolerance

I need a Formula where I can get
In Tolerance when its less than 0,5% and Not in Tolerance when its greater than 0,5%
In Tolerance when its less than -0,5% and Not in Tolerance when its greater than -0,5%


I tried =IF(J3<0,5%;"Tolerance"; "Not in Tolerance")  but works not as expected, fails when its -0,5%

Hola,

=if(abs(J3)<0,5%.....

Gruß,
steve1da

I knew ABS, but a knock on my head was required, could not relate to this situation - thanks Steve

Helo,

in some Situations it may be needfull to use boolean functions like OR or AND

steve's example ist the shortest solution, but in the other way you have this Version:

=IF(OR(J3<0,5%;J3>-0,5%);"Tolerance"; "Not in Tolerance")

Danke