Conditional Logicbeginner
Nested IF grade scale
=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))
Function reference
IF in Excel & Google Sheets
IF is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 beginnerBuild a custom IF formula →
When to use IF
- Assign grades, bands, or labels when one numeric value needs to map to several ranges.
Worked examples (1)
Common errors with IF
Wrong grade bands
Threshold checks must run from highest to lowest or earlier checks will catch values that belong to a later grade.
Frequently asked questions
Should I use IFS instead?
If your Excel version supports IFS, it is usually easier to read and maintain than multiple nested IF calls.
Need a custom variation?
Describe your specific IF problem and get a formula written for your exact data.
Open generator with IF