If Condition

[sathsaj]

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%

[steve1da]

Hola,

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

Gruß,
steve1da

[sathsaj]

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

[schauan]

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")

[sathsaj]

Danke