Number range

[Np72]

hi.

Trying to write a if/or statement and I'm stuck, here's what I'm trying to do -

If Cell A is greater than 0.01 (ie 0.11) flag "Over tolerance2, if cell A is greater than -0.01(ie -0.11) flag "Over tolernance". Anything between -0.01 and 0.01 is fine

Thanks

Np

 

[VoG]

Try

=IF(ABS(A1)>0.01,"Over tolerance","")