### IFS(logical_text1, value_if_true1 [,logical_text2, value_if_true2] [..])

Returns the value based on multiple True or False conditions.

 logical_text1 Condition that evaluates to True or False. value_if_true1 Result if the logical value evaluates to True. logical_text2 Condition that evaluates to True or False. value_if_true2 Result if the logical value evaluates to True.

#### Remarks

 * Added in Excel 2019.* For an illustrated example refer to the page under Advanced Functions.* To specify a default result add 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 a logical test does not evaluate to either True or False, then #VALUE! is returned.* 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.* For the Microsoft documentation refer to support.microsoft.com

 A B C 1 =IFS(B1=10,C1,B2=20,C2) = one 10 one 2 =IFS(B2=15,C1,B2=20,C2) = #N/A 14 two 3 =IFS(B1>10,"false",TRUE,"something else") = something else 41 4 =IFS(FALSE,"1stFalse",FALSE,"2ndFalse",TRUE,"1stTrue") = 1stTrue one 5 =IFS(B1*"some text","not logical") = #VALUE! two 6 =IFS(B1>10,"B1",B2>20,"B2",B3<30,"B3") = #N/A

 1 - What value is returned when the logical test "B1=10" is evaluated.2 - What value is returned when the logical test "B2=15" is evaluated.3 - What value is returned when the logical text "B1>10" is evaluated.4 - What is returned when the first two logical tests evaluate to False.5 - What is returned when the logical test is not a valid expression.6 - What is returned when none of the logical tests are True.