Map a number to a grade or category using IFS — cleaner than nested IFs.
Copy this formula
=IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", TRUE, "F")IFS checks each condition in order and returns the first match. List conditions from highest to lowest, and end with TRUE as the catch-all default. It avoids deeply nested IF parentheses.
=IFS(A2>=1000, "Gold", A2>=500, "Silver", TRUE, "Bronze")→SilverTiers a spend of 650 as Silver.
Nested IF (older Excel)
=IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","F")))Use when IFS isn't available.
No condition matched. Add a final TRUE, <default> pair as the catch-all.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.