How to Use IFS Function in Excel Step-by-Step with Examples

Hello everyone! Today i will show you how to use IFS function in Excel step by step.

What is IFS Function in Excel?

The IFS function help you check multiple conditions at the same time and return the result for the first TRUE condition. In old Excel, you need write long nested IF(IF(IF...)) formula, but IFS formula make your work much clean and easy to read!

📚 Related Tutorial: Want to learn basic single IF formula first? Check out How to Use IF Function in Excel!

🛠️ Formula Syntax

=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

• logical_test1: First condition you want to check (example: A2 >= 90).
• value_if_true1: Result to return if first condition is TRUE (example: "A").
• logical_test2, value_if_true2: Second condition and result if second condition is TRUE.
• You can add up to 127 different conditions in one formula!

📊 Simple Examples

Example 1: Student Grade Calculation

We want to convert student score in cell A2 into letter grade:

=IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", A2>=60, "D", A2>=50, "E", A2<50, "F")

Example 2: Sales Bonus Rate

If sales total is in cell B2, calculate bonus percentage:

=IFS(B2>=10000, "15% Bonus", B2>=5000, "10% Bonus", B2>=1000, "5% Bonus", TRUE, "No Bonus")

Example 3: Shipping Fee based on Order Total

Check order total in cell C2 to assign shipping fee automatically:

=IFS(C2>=100, "Free Shipping", C2>=50, "$5 Shipping", C2>0, "$10 Shipping", TRUE, "Invalid Amount")

Example 4: Task Status Classification

Check text status in cell D2:

=IFS(D2="Completed", "Done", D2="In Progress", "Working", D2="Pending", "Waiting", TRUE, "Unknown")

Example 5: Combine IFS with AND Function (Multiple Conditions)

If student need pass both Exam score (Cell A2) and Attendance rate (Cell B2):

=IFS(AND(A2>=80, B2>=80), "Distinction", AND(A2>=50, B2>=50), "Pass", TRUE, "Fail")

💡 Quick Tips for IFS Function:

1. Use TRUE at the end as default fallback: Always put TRUE, "Default Result" as final pair. If no condition matches and you don't add TRUE, Excel will return #N/A error!
2. Order is very important: Excel check condition from left to right. Once it find first TRUE condition, it stop checking immediately! Always put highest or most specific condition first.

📚 Related Resources & Tutorials

• How to Use IF Function in Excel
• SUMIF vs SUMIFS in Excel: Easy Guide
• Top 15 Basic Excel Formulas for Beginners ↗