What is the IFS Function
The IFS function checks multiple conditions in order and returns the value for the first condition that is true. It is a cleaner alternative to deeply nested IF functions and makes multi-condition logic much easier to read.
Formula: =IFS(condition1, value1, condition2, value2, ...)
Practical Example 1
Marks in B2. Grade scale: 80 or above A, 60 or above B, 40 or above C, else Fail.
Type: =IFS(B2>=80, A, B2>=60, B, B2>=40, C, TRUE, Fail)
Result: A, B, C, or Fail
Practical Example 2
Assign a discount tier based on purchase amount.
Type: =IFS(B2>=5000, 20 percent, B2>=2000, 15 percent, B2>=1000, 10 percent, TRUE, 0 percent)
Result: the discount rate
Practical Example 3
Assign performance levels based on score.
Type: =IFS(B2>=90, Excellent, B2>=75, Good, B2>=60, Average, TRUE, Needs Improvement)
Result: the performance label
When to Use It
IFS is used for grade assignment, salary banding, performance tiers, discount slabs, and any multi-condition logic where nested IF would become hard to read.