Conditional IF statement

[Stibbz]

Hi,

I am trying to do a conditional IF statement within Excel 2010 so that IF a value is <= +/- 1.96 then write "PASS" if not then write "FAIL"

Any help on how to do this??

[Jacc]

Please Login or Register  to view this content.

[Stibbz]

Thanks, what does the 'abs' function do?

[Jacc]

You are welcome. Absolute value. It removes the minus sign.