IFS Function

🎯Purpose

Evaluates multiple conditions sequentially without requiring messy nested IF statements.

Syntax

EXCEL

=IFS(condition1, value1, [condition2, value2], ..., [TRUE, fallback_value])