IFS function in Excel

What is IFS function in Excel?

The IFS function is one of the Logical functions of Excel.

It checks whether one or more conditions are met and returns a value corresponding to the first TRUE condition.

We can find this function in the Logical category of the insert function Tab.

How to use IFS function in excel

1. Click on an empty cell (like F5 )

empty cell in excel

2. Click on the fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

insert function tab

4. Select Logical category

5. Select IFS function

6. Then select ok

IFS function in excel

7. In the function arguments Tab you will see the IFS function

8. Logicaltest1: enter any value or expression that can be evaluated to TRUE or FALSE

9. Value if true1: is the value returned if the logical test is TRUE

10. Logical_test2: enter any value or expression that can be evaluated to TRUE or FALSE

11. Value if true2: is the value returned if the logical test is TRUE

12. You will see the result in formula result section

How to use IFS function in excel

Examples of IFS function in excel

What is the purpose of IFS function?

What is the Return value  of IFS function?

How many arguments does IFS function have?

This function has just 1 Argument.

The argument of ABS function is number.

The argument of ABS function is required and not optional.

Which version of excel supports IFS function?

This function is available for all excel versions (2003-2019)

Errors in IFS function

IFS related functions

Leave a Reply

Your email address will not be published. Required fields are marked *