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 )
2. Click on the fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select Logical category
5. Select IFS function
6. Then select ok
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
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
- IF function
- CHOOSE function
- SWITCH function
- VLOOKUP function
- MATCH function
- SUMIFS function
