Math & Statisticsintermediate
SUMIFS for monthly revenue by category
=SUMIFS($D:$D,$B:$B,$G$2,$C:$C,">="&DATE(2026,1,1),$C:$C,"<"&DATE(2026,2,1))
Excel how-to guide
How to nested if grade scale in Excel
Assign grades, bands, or labels when one numeric value needs to map to several ranges.
Step-by-step instructions
How to nested if grade scale — 3 steps
1
Start with the highest threshold first so strong scores are classified immediately.
2
Nest each next IF inside the previous false branch to handle the next grade band.
3
Finish with the fallback value for anything below the final threshold.
Example data
Worked example
| Score | Grade |
|---|---|
| 95 | A |
| 82 | B |
| 67 | D |
Common mistakes
Errors to watch out for
Wrong grade bands
Threshold checks must run from highest to lowest or earlier checks will catch values that belong to a later grade.
FAQ
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.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides