IFS

Definition: IFS is a function that evaluates multiple conditions and returns a value corresponding to the first true condition.

Syntax: =IFS(condition1, value1, [condition2, value2], …)

Situation: This formula is suitable when you need to evaluate multiple conditions and return a value corresponding to the first true condition.

Example: If you have a test score of 85, and want to determine the corresponding letter grade, the formula =IFS(A1>=90, “A”, A1>=80, “B”, A1>=70, “C”, A1>=60, “D”, TRUE, “F”) can be used.