IFS

Returns a value corresponding to the first true condition

Updated over a week ago

Description

IFS() assesses multiple conditions and their corresponding values, returning the value linked to the first true condition. This function is beneficial for handling scenarios with multiple criteria.

Syntax

IFS(condition1, value1, condition2, value2, , )

Output

text

Variables

  1. condition1: First logical condition to be evaluated.

  2. value1: Value returned if condition1 is true.

  3. condition2: Second logical condition to be evaluated.

  4. value2: Value returned if condition2 is true.

  5. , : Additional logical conditions to be evaluated and their values returned if true.

Example

IFS(`Profit`≥1000,”Excellent”,`Profit`≥500,”Good”,`Profit`<100,”Bad”)

Investment

Profit

IFS

Investment A

$500

Good

Investment B

-$200

Poor

Investment C

$1200

Excellent

Did this answer your question?