IFS Function in Google Sheets — Syntax, Examples & Tips

Syntax

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

Evaluates multiple conditions and returns the value for the first TRUE condition.

Cleaner than nested IFs. Add TRUE as last condition for a default value.

=IFS(...)

The IFS function belongs to the Logical category of Google Sheets functions.

IF — Returns one value if a logical expression is TRUE and another if FALSE....
IFERROR — Returns the first argument if it is not an error value, otherwise returns the se...
IFNA — Evaluates a value. If the value is an #N/A error, returns the specified value....
AND — Returns TRUE if all arguments are TRUE....
OR — Returns TRUE if any argument is TRUE....
NOT — Returns the opposite of a logical value....

If you're struggling with IFS or need a custom formula built for your business, our Google Sheets experts can help. Get a free quote →