Ifs

Syntax

Ifs(LogicalValue1, ConditionValue1, …)

LogicalValue1, LogicalValue2, …, LogicalValueN. Logical condition.

ConditionValue1, ConditionValue2, …, ConditionValueN. The value, if the condition is set to TRUE.

It checks for correspondence with one or several conditions and returns value for the first condition, which is set to TRUE.

One can set up to 127 conditions.

Parameter values can include numbers, empty cells, logical values, cell references, formulas.

Numbers are interpreted as TRUE, and empty cells are interpreted as FALSE.

Formula	Result	Description
=Ifs(K7, 1, K8, 2, G10, 4)	4	The value for the third condition, which is the first to set to True.