Quick Answer & Formula
Excel
Sheets
Beginner
=IFS(condition1, value1, [condition2, value2, ...], [TRUE, default_value]) The IFS function checks multiple conditions in sequential order and returns the value corresponding to the first TRUE condition. Add TRUE as the final condition to define a fallback/else default value.
IFS Function in Excel & Google Sheets
The IFS function evaluates multiple conditions in sequence without requiring deep parentheses nesting.
1. Grade / Performance Tier Example
=IFS(
B2 >= 90, "Grade A",
B2 >= 80, "Grade B",
B2 >= 70, "Grade C",
B2 >= 60, "Grade D",
TRUE, "Grade F"
)2. Order Shipping Priority Example
=IFS(
C2 = "Overnight", 25.00,
C2 = "2-Day Express", 15.00,
C2 = "Standard", 5.00,
TRUE, 0.00
)
?
Frequently Asked Questions
How do I set a default 'Else' value in an IFS formula?
Add TRUE as the final test condition: =IFS(B2>=90, "A", B2>=80, "B", B2>=70, "C", TRUE, "F").