Background
Processing of Slabs requires nested IF approach. Construction of formula for achieving output becomes complex as multiple IF function are written inside IF. Closing of Braces or Correction of formula becomes painful task.
IFS function was introduced to solve this difficulty.
Syntax
=IFS(condition-1,true_expr-1,condition-2,true_expr-2,...,condition-n,true_expr-n)
IFS function is almost same as IF except, for a minor difference of absense of FALSE statement. If the condition does not get satisfied, then it moves on to next condition, untill it finds TRUE condition
Example
Grading system for subjects based on marks in given below. We want to calculate grade based on the marks.
| Marks | Grade | |
|---|---|---|
| 90 or above | A | |
| 80 or above | B | |
| 70 or above | C | |
| 60 or above | D | |
| 50 or above | E | |
| Below 50 | F |
=IFS(B1>=90,"A",B1>=80,"B",B1>=70,"C",B1>=60,"D",B1>=50,"E",TRUE,"F")
Rank:
Watch Tutorial
Try Online
