Functions
IFS
First value whose condition is true
Try it
When to use it
When should I use IFS instead of nested IF statements?
Use IFS when you have several conditions to test in order; it is flatter and easier to read than nesting many IF functions inside each other.
What does IFS return if no condition is true?
IFS returns an #N/A error if none of the conditions match, so add a final TRUE condition as a catch-all default when you need one.
Use cases
Pick the first matching branch
Use a TRUE catch-all as the default
Used in
Syntax
IFS(cond1, val1,...)