# How to use IFS Function in Google Sheets (With Examples) • The best way you can use the IFS Function in Google Sheets: Prepare your sample data with students’ names and marks > Create a table for grading criteria with conditions and corresponding grades > In a cell, write the IFS function > Begin by checking the first condition. For example, =IFS(B4 < \$E\$5, \$F\$5), where B4 is the student’s mark, E5 is the lower limit, and F5 is the corresponding grade > Continue like this, then press Enter.

IFS function is nothing but a combination of IF, which means that if we can use more than 1 condition in the IF then it will become IFS, which means the plural of If. Now you can guess what else this function can do. This can be referred to as Nested If else in the programming context. In almost every programming language we have an IF statement, and most probably we use IF else nested to examine multiple conditions together. Also, we can refer to IFS with the “Switch” statement in the context of general-purpose programming languages like Python and JavaScript.

Here IFS makes it very easy and simple to work on multiple conditions. Using if we can examine one condition such as do this if the value is greater than 100. but, in IFS we can examine multiple conditions together such as to that if the value is greater than this, this, this, and this. Now “this” is the values here that will be matched separately by the IFS and then a result will be brought.

## Use Cases of IFS Function in Google Sheets

We many times need to work with IF else, and for that, we match some conditions with the values, we most times need to check the value with multiple conditions, so IFS is the solution for this. We can match multiple conditions (as many as we want) using IFS. There are many use cases (we will see later in this tutorial) that are required to perform multiple IF on that, but instead of using multiple If conditions we can easily use IFS to check more than one condition with only one formula and we can dynamic results using IFS.

Let’s move to practical learning in the below sections. We will learn some use cases to understand the need for the IFS function.

## How to use IFS Function in Google Sheets

Here, we will learn how to learn IFS using some practical examples and real-life applications of IFS where we need to check more than one condition to bring out a single value.

syntax

=IFS(Condition1, Value1, [Condition2, Value2],…)

Here, condition 1 is any condition we want to check, then the value 1 after the comma, similarly after this we can continue the same syntax condition2, value2, and so on.

### How to use IFS Function in Google Sheets – Calculate Students’ Grade

In this section, we will learn how to use the IFS function in google sheets to calculate the grade of the students based on their marks.

For this example, I have a dataset with students’ names and marks, and a small table of grading criteria where the criteria are written.

I will use the IFS function here to check all the conditions and where the marks matched, the adjacent grade will be assigned to the student. It’s pretty much like a VLOOKUP function.

Step 1

Sample data Step 2 Step 3

Start writing the IFS function Step 4

Pass the condition to check let’s say the condition is (A2<E3, F4) Step 5

Now following a similar pattern, you can pass all the conditions by adding commas between them Step 6

The final formula will be:

=IFS(B4<\$E\$5,\$F\$5,B4<\$E\$6,\$F\$6,B4<\$E\$7,\$F\$7,B4<\$E\$8,\$F\$8,B4<\$E\$9,\$F\$9,B4<\$E\$10,\$F\$10,B4<E\$11,\$F\$11,B4<\$E\$12,\$F\$12) Step 7

Hit enter and drag down the formula to copy   You have got the appropriate grades of the students based on their marks.

This is how to use IFS Function in google sheets to calculate the Grade based on students’ marks.

### How to use IFS Function in Google Sheets – Calculate Employees’ Incentives

In this section, we will learn how to use the IFS function in google sheets to calculate employees’ incentive amount based on their number of off days in the previous project duration. We will give good incentives if the off days are low, and no incentive if the off days are more than a certain number.

For this example, I have a sample dataset and also a table of incentive criteria.

Let’s see how it’s done.

Step 1

Sample data Step 2

Incentive criteria table Step 3

Write the IFS function Step 4

Pass the conditions for every criterion in the incentive criteria table. (Here we will use the equal to the operator instead of less than the operator, because the number of days is fixed from 0 to 7 there is nothing in between so we will go for exact matches)

Step 5

The final formula will be:

=IFS(J4=\$M\$5,\$N\$5,J4=\$M\$6,\$N\$6,J4=\$M\$7,\$N\$7,J4=\$M\$8,\$N\$8,J4=\$M\$9,\$N\$9,J4=\$M\$10,\$N\$10,J4=\$M\$11,\$N\$11,J4=\$M\$12,\$N\$12) Step 6

Press Enter key and you’re done.  This is how to use the IFS function in google sheets to calculate the incentive amount for each employee based on their number of days off.

### How to use IFS Function in Google Sheets – Calculate Delivery Charges

In this section, we have another use case. We will learn how to use the IFS function in google sheets to calculate the delivery charges for the customers based on their total shopping amount. We have to sample data and also a table called Delivery Charges Criteria. We will use the same approach to solve this and find the Delivery charges value by checking the shopping bill amount in the criteria table.

Step 1

Sample data Step 2

Delivery charges criteria table Step 3

Write the IFS formula Step 4

Pass the conditions and compare the shopping bill with each value in the criteria table  (Here we will use the greater than the operator because we do not have exact values so we will compare with the greater than the operator)

Step 5

The final formula will be:

=IFS(S4>\$V\$8,\$W\$8,S4>\$V\$7,\$W\$7,S4>\$V\$6,\$W\$6,S4>\$V\$5,\$W\$5) Step 6

Press Enter key, and you’re done. This is how to use the IFS function in google sheets to calculate the delivery charges for each customer based on their total spending.

### Comparison: IF vs IFS function in Google Sheets

• I can check only one condition and return the result based on the value.
• IF returns a single value based on the condition either true or false.
• IFS can check as many conditions as you want
• IFS requires to pass three arguments for each condition
• IFS cannot have custom results if the condition is false, although you can print a custom message only when the condition is true.  