BeginnerEducationAbout 6 minutes
Sample data
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Student | Maths | Science | English |
| 2 | Layla | 78 | 85 | 91 |
| 3 | Omar | 62 | 70 | 58 |
| 4 | Priya | 95 | 88 | 92 |
| 5 | Quinn | 45 | 52 | 61 |
| 6 | Rosa | 88 | 79 | 84 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
Start with a simple question: is Omar’s Maths score at least 60?
Result
IF turns that yes or no into words.
Result
Use an average of all three subjects instead.
Result
Combine them: pass if the average is at least 60.
Result
For letter grades use IFS. The first true test wins, so go from the highest.
Result
Find the class average for Maths to compare.
Result
What to remember
IF handles two outcomes. IFS handles several, in order, and TRUE at the end catches everything else.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.