Savant

<code>condition1</code>: First logical condition to be evaluated.

<code>value1</code>: Value returned if <code>condition1</code> is true.

<code>condition2</code>: Second logical condition to be evaluated.

<code>value2</code>: Value returned if <code>condition2</code> is true.

<code>…</code> , <code>…</code>: Additional logical conditions to be evaluated and their values returned if true.

1. <code>condition1</code>: First logical condition to be evaluated.
2. <code>value1</code>: Value returned if <code>condition1</code> is true.
3. <code>condition2</code>: Second logical condition to be evaluated.
4. <code>value2</code>: Value returned if <code>condition2</code> is true.
5. <code>…</code> , <code>…</code>: Additional logical conditions to be evaluated and their values returned if true.

IFS(`Profit`≥1000,”Excellent”,`Profit`≥500,”Good”,`Profit`&lt;100,”Bad”)

Returns a value corresponding to the first true condition

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

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

Investment	Profit	IFS
Investment A	$500	Good
Investment B	-$200	Poor
Investment C	$1200	Excellent

Variables

Example