Lab › Formulas & Functions › Grades with Nested IF
Grades with Nested IF: Excel Lab
Lab 07 · IntermediateIFNested IF
The task: Give a grade for each student: 90+ = A+, 75+ = A, 60+ = B, 40+ = C, below 40 = F.
1 Watch how it is done
Step 1: Write the nested IF
=IF(B4>=90,"A+",IF(B4>=75,"A",IF(B4>=60,"B",IF(B4>=40,"C","F"))))- Click C4.
- Type =IF(B4>=90,"A+",IF(B4>=75,"A",IF(B4>=60,"B",IF(B4>=40,"C","F")))) and press Enter.
- Check the brackets: one IF inside the next, four closing brackets at the end.
- Drag the fill handle down.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Grades with VLOOKUP →
Want the theory? Read the Formulas & Functions lessons →
← More Formulas & Functions labs · All lab categories
