Explanation
IFS checks multiple conditions in order and returns the result of the first TRUE condition.
Syntax
=IFS(test1,result1,test2,result2,…)
Grade Calculator
|
Marks |
Grade |
|
90+ |
A+ |
|
75–89 |
A |
|
60–74 |
B |
|
40–59 |
C |
|
Below 40 |
Fail |
Formula
=IFS(B2>=90,”A+”,B2>=75,”A”,B2>=60,”B”,B2>=40,”C”,B2<40,”Fail”)
Important
It is important to place the conditions in the correct order.
Practice
Create an automatic Grade Calculator using marks of 20 students.