Trying to fill a field in excel with 3 different wordfs based on another field result

Hello Brian128​, 

Step 1. In cell G8, enter one of these formulas: 

=IF(G7<=32%,"Bad Deal",IF(G7<=74%,"Fair Deal","Good Deal")) 

or =IFS(G7<=32%,"Bad Deal",G7<=74%,"Fair Deal",G7>=75%,"Good Deal")

This will display:

• 0–32% → Bad Deal
• 33–74% → Fair Deal
• 75–100% → Good Deal

Step 2. Apply conditional formatting to G8 based on G7:

Red: =G7<=32%
Yellow: =AND(G7>32%,G7<=74%)
Green: =G7>=75%

Step 3. Test it:

• If G7 = 25% → G8 shows Bad Deal in red
• If G7 = 50% → G8 shows Fair Deal in yellow
• If G7 = 80% → G8 shows Good Deal in green

Other variants

=LOOKUP(G7, {0, 0.33, 0.75}, {"Bad", "Fair", "Good"} ) & " Deal"

=IF( G7 >= 0.75, "Good Deal",
 IF(G7 >= 0.33, "Fair Deal", "Bad Deal")
)

=SWITCH( TRUE,
    G7 >=0.75, "Good Deal",
    G7 >=0.33, "Fair Deal",
    G7 >=0,    "Bad Deal"
)

You need to become acquainted with the IFS function. It should be very straight forward.  Depending, though, on the degree of precision, you may need to do some finagling to get 32.5% (for example) to display the right words and color.

Or go at it backwards: IFS stops at the first successful match, so you could write it:

=IFS(G7>.75,"Good Deal",G7>.33,"Fair Deal",G7>0,"Bad Deal")