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