Excel Function

IFS

Evaluates multiple conditions in order.

IFS(logical_test1, value_if_true1, ...)

Arguments

logical_test1

Required

Enter an expression such as comparison or calculation.

value_if_true1

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

show outputs based on conditions. Use IFS to Evaluates multiple conditions in order. For logical_test, enter a condition expression that returns TRUE/FALSE. use C2>=90 for logical_test1, use "A" for value_if_true1. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=IFS(C2>=90, "A")

Practice This Function

Practice in Sequential Mode Back to Function List