- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Logical - IFS Function
Description
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. This Function was added in Excel 2016.
Syntax
IFS (logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3, value_if_true3]…)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
logical_test1 | Condition that evaluates to TRUE or FALSE. | Required |
value_if_true1 | Result to be returned if logical_test1 evaluates to TRUE. Can be empty. | Required |
logical_test2…logical_test127 | Condition that evaluates to TRUE or FALSE. | Optional |
value_if_true2…value_if_true127 | Result to be returned if logical_testN evaluates to TRUE. Each value_if_trueN corresponds with a condition logical_testN. Can be empty. | Optional |
Notes
As functions are limited to 254 parameters, you can use up to 127 pairs of condition and result arguments.
To specify a default result, enter a condition that will always be true for your final logical_test argument, such as TRUE or 1=1. The corresponding value will return, if none of the other conditions are met.
If a logical_test argument is supplied without a corresponding value_if_true, IFS shows the typical "You've entered too few arguments for this function" error message.
If a logical_test argument is evaluated and resolves to a value other than TRUE or FALSE, IFS returns a #VALUE! Error.
If no TRUE conditions are found, IFS returns #N/A! error.
Applicability
Excel 2016