Nested ifs

[MGT]

Hi group
Can anyone help - I need to show Pass / Fail column if test results in two
columns meet two seperate criteria...
Column A needs to have a result between -3.0 and +5.0%
Column C needs to have a result between 95 and 105%
The third column needs to show "PASS" if both conditions are met, otherwise
"FAIL"

I've tried to nest the ifs, but am getting the syntax wrong somewhere...
Thanks - Marcie

 

[Frank Kabel]

Hi
try

 

[JE McGimpsey]

One way:

=IF(AND(ABS(1%-A1)<=4%, ABS(1-C1)<=5%),"PASS","FAIL")

 

[MGT]

Thanks Frank - that's worked a treat...

Hi
try