IFS

This function performs a comparison and returns the specified associated value if comparison is TRUE.

Syntax

IFS(condition, value1, [condition2, value2], ...)

This function has the following arguments:

Argument	Description
condition1	[Required] Refers to a value or expression to evaluate.
value1	[Required] Refers to a value to return if the test evaluates to true.
[condition2,value2], ...	[Optional] Refers to more conditions to be compared (nested IF statements).

This function allows users to test up to 127 different conditions.

IFS(A2>89,"A",A2>79,"B") gives the result B.