IFS Function in Excel: Syntax, Examples and Free Practice
IFS is an Excel Logic function. Checks multiple conditions in order and returns the value for the first one that's true.
IFS syntax
Arguments
logical_test1: The first condition to checkvalue1: The first valuelogical_test2: An additional condition to check (optional)value2: An additional value (optional)
When to use IFS
IFS is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice IFS online, free
Open the live Excel-style spreadsheet and try IFS yourself. No Excel install or sign-up needed to start.
Practice IFS now →Learn more
Read the tutorial: IF with AND / OR.
IFS practice questions
- Write A for marks 90 or more, B for 60 or more, otherwise C. Put the grade in C2 to C4.
- Write Absent if the marks cell is empty, Pass if the marks are 40 or more, otherwise…
- Work out the commission: 10% of the sales if they are 100000 or more, 5% if they are…
- Find the shipping charge by weight: up to 1 kg is 40, up to 5 kg is 90, up to 10 kg is…
- Write the department name from the code start: HR is Human Resources, FIN is Finance,…
- Rate each student on two marks: Star if both are 90 or more, Good if at least one is 90…
- Find the amount (quantity times price) with a discount on the whole amount: 20% off for…
- Write the quarter for each month name: Jan to Mar is Q1, Apr to Jun is Q2, Jul to Sep is…
- Scores are in B2:B7. Grade them in D2:D7: 90 and above is A, 75 and above is B, 60 and…
More Logic functions
Frequently asked questions
What does the IFS function do in Excel?
Checks multiple conditions in order and returns the value for the first one that's true.
What is the syntax of IFS in Excel?
The syntax is =IFS(logical_test1, value1, [logical_test2, value2], ...). logical_test1: The first condition to check; value1: The first value; logical_test2: An additional condition to check (optional); value2: An additional value (optional).
Where can I practice IFS online for free?
Open the free live spreadsheet on Cellgrids and try IFS yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts