IFS

The IFS function checks multiple conditions and returns a value corresponding to the first TRUE condition.

Syntax

=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

Parameters

• logical_test1: First condition to evaluate
• value_if_true1: Value to return if first condition is TRUE
• logical_test2, value_if_true2, ...: Additional condition/value pairs (optional)

Examples

=IFS(A1>90, "A", A1>80, "B", A1>70, "C", TRUE, "F") // Grade calculation
=IFS(B1="Red", 1, B1="Blue", 2, B1="Green", 3, TRUE, 0) // Color coding
=IFS(C1<0, "Negative", C1>0, "Positive", TRUE, "Zero") // Number classification