Nested If Statements using negative numbers

[ldurham]

I'm trying to create a formula , possible an if statement , but there may be a better way to accomplish what I need, I attached the excel sheet showing the legend, with the explanation, thanks to anyone who is willing to take a look, LaDonna
See attached. Thanks

[CAntosh]

This should satisfy your sample workbook. If you format the cell in question (F9 in the sample) as a percentage, then you'll need to modify the numbers of my formula to reflect that excel is now working with decimals, but the structure of the formula below should accomplish what you have in mind. Use conditional formatting if you want the colors to change.

=IF(ABS(F9)>=5,"No Good",IF(ABS(F9)<3,"Passing","Good"))

[JohnTopley]

Create table as below: in L6:M8 in the example below

0.0 Passing
3.0 Good
5.0 No Good

in G9

=VLOOKUP(ABS($F$9),$L$6:$M$8,2,1)

[ldurham]

THANK YOU ! both options worked great,