Trying to create a formula for +\-

[chona76]

HI! Newbie here...

need to create a formula to show Pass or Fail for +\- 5%. So, anything over 6% and -6% would be fail and everything else would be Pass.

Thanks.

[jdlucasps7]

Newbie here as well but assuming you have a target value........if the absolute difference between the actual value and target is more than or equal to your tolerance then pass or fail. =if(abs(variance)>=tolerance,"fail","pass"). Substitute cell ranges for where your variance and tolerances are.

[FDibbins]

or try this...

=and(cell_value>.06,cell_value<-.06,),"FAIL","PASS")

[chona76]

Newbie here as well but assuming you have a target value........if the absolute difference between the actual value and target is more than or equal to your tolerance then pass or fail. =if(abs(variance)>=tolerance,"fail","pass"). Substitute cell ranges for where your variance and tolerances are.

or try this...

=and(cell_value>.06,cell_value<-.06,),"FAIL","PASS")

Thanks, but its not what I was looking for. I need it to be where, if F2 is 5% to -5% I want G2 to say PASS. but if it is 6% and up as well as -6% and up, I need G2 to say FAIL. I hope I explained that right. Currently, I had =IF(F2<=5%,"Pass","Fail") But when it was -6% it did not register as FAIL. I can't get it to understand the NEGATIVE.