How to Use IFS Logical Function in Google Sheets [Also Nested IF]

0
682
How to Use IFS Logical Function in Google Sheets

Before learning how to use IFS logical function in Google Sheets, you should know the use of logical function IF. IF logical function helps you to check the value in one cell and get with a result that is True or False.

If you are not aware of Logical Functions in Google Sheets or Excel, you are not using the potential of spreadsheet in its fullest form. Logical functions are great time savers.

Here in this Google Sheet tutorial we will learn the use of IF, Nested IF and IFS functions.

Additional Reading: IF, AND, OR are the very popular Logical functions in Google Sheets [Also in Excel].  Learn these killer Google Sheet functions from our below tutorial.

Combined Use of IF, AND, OR Logical Functions in Google Doc Spreadsheet

Below we can learn how to use IFS logical function. IF and IFS logical functions are standalone logical functions. So no need for you to learn IF logical function first to learn IFS.

What is the difference between IF and IFS logical functions?

IFS logical function is equal to nested IF. That means you can use nested IF same as IFS.

Let’s Now See How to Use IFS Logical Function in Google Sheets

IFS syntax:

=IFS(condition1, value1, [condition2, value2], …)

Example:

=IFS(A1=1,”One”, A1=2, “Two”, A1=3, “Three”)

In the example IFS function check the value in cell A1. If the value in cell A1=1 [condition 1], you will get the result “One”, if the value in cell A1=2 [condition 2], you will get the result “Two” or if the value in cell A1=3 [condition 3] you will get the result “Three”.

Thus IFS logical function checks the value in a cell with different conditions and return the result. IF function we have already learned in an earlier post HERE. Still once again we can see it to understand the difference with IFS.

IF syntax:

=IF(logical_expression, value_if_true, value_if_false)

Example 1:

=IF(A1=1,”One”,”Different Value”)

In this example, same as IFS, check the value in cell A1. If the value in cell A1=1 [Logical Expression], you will get the result “One”, else “Different Value”.

Example 2:

=IF(A1=1,”One”)

In this case if value in cell A1=1, the result will be “One”, else “False”.

So you learned IF and IFS logical functions. Then how to use IF logical function instead of IFS? See the example below.

=IFS(A1=1,”One”, A1=2, “Two”, A1=3, “Three”)

=IF(A1=1,”One”,IF(A1=2,”Two”,IF(A1=3,”Three”,”Different Value”)))

The above two formula will give you the same result. The second formula is the example to the use of nested IF.

What is the advantage of IF logical function over IFS?

If you carefully analysis the last two examples, you will see the difference. Nested IF has a slight advantage over IFS, even though its little bit complex in use.

IFS evaluates multiple conditions and returns the value based on a true condition.

Nested IF evaluates multiple conditions and returns one value if the condition is true or another value if the condition is false. In other words IFS check for true condition while IF checks for true and false. This is the difference between nested IF and IFS.

Copy our Google Sheet file below to learn the difference of IFS and nested IF.

Download

In this post we explaied the following things;

How to use IFS logical functions in Google Sheets, How to use IF logical function in Google Sheets, How to use Nested IF in Google Sheets and the difference or similarities between Nested IF and IFS functions.

If you have any query regarding the use of the above logical functions, do post in comments.

LEAVE A REPLY

Please enter your comment!
Please enter your name here