In Google Sheets, you can use the IFS function to test multiple conditions at once and then return the result based on it.
The difference between the IF function and the IFS function is that in IFS function, you can test multiple conditions at once. As soon as the condition is found to be TRUE, its corresponding value is returned.
This Tutorial Covers
IFS function can test multiple conditions and returns the value as soon as it finds the first condition that is fulfilled.
This makes this function ideal for situations where you need to find the grade for students based on their score. Another situation where it can come in handy is when you have to calculate the commission based on the sales values (these will be covered in examples below).
Let’s first have a look at the syntax of IFS function in Google Sheets.
=IFS(Condition1, Value1, [Condition2, Value2],…)
As I mentioned earlier, this function is best suited for situations where you need to check conditions in a sequence and return the value for the first condition that is met.
This makes it ideal for situations where you have to grade students or find commissions for the sales team.
Suppose you’re the head of the sales department and it’s time to give out commissions based on the sales done by each employee.
Below is the formula that will give you the commission value for each sales personnel:
Suppose you have the scores for students in an exam as shown below (column A) and the grading conditions in column C and D.
Below is the formula that will give you the grades for each student:
You May Also Like the Following Google Sheets Tutorials: