IFS |
IFS(logical_test1, value_if_true1 [,logical_test2, value_if_true2] [..]) |
Returns the value based on multiple True or False conditions. |
logical_test1 | Condition that evaluates to True or False. |
value_if_true1 | Result if the logical value evaluates to True. |
logical_test2 | (Optional) Condition that evaluates to True or False. |
value_if_true2 | (Optional) Result if the logical value evaluates to True. |
REMARKS |
* This function was added in Excel 2019 to remove nested IF functions. * For an illustrated example refer to the page under Advanced Functions * For an overview of conditional formulas refer to this page * This function is not case sensitive when matching text strings. * This function does not support wildcards (? and *). * It is possible to specify a default value by adding a condition that will always be true as your last condition. * If you do not provide a corresponding value for each logical test then the pop up message "you have entered too few arguments for this function" is displayed. * If any logical_text argument does not evaluate to either True or False, then #VALUE! is returned. * You can have a maximum of 127 (logical_tests and values). * If no conditions are found, then #N/A! is returned. * If the function is not available, then #NAME? is returned. * You can use the IF function to return a value based on one condition. * You can use the IFERROR function to return the value or something else if it evaluates to an error. * You can use the SWITCH function to return a value based on a list of exact matches. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - What value is returned when cell "B2" equals 14 using nested IF functions. 2 - What value is returned when cell "B2" equals 14 without nested IF functions. 3 - What value is returned when cell "B4" equals "one" using nested IF functions. 4 - What value is returned when cell "B4" equals "one" without nested IF functions. 5 - What value is returned when cell "B4" equals "one" using the SWITCH function. 6 - What value is returned when the logical test "B1=10" is evaluated. 7 - What value is returned when the logical test "B2=15" is evaluated. 8 - What value is returned when the logical text "B1>10" is evaluated. 9 - What is returned when the first two logical tests evaluate to False. 10 - What is returned when the logical test is not a valid expression. 11 - What is returned when none of the logical tests are True. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top