If all expressions are FALSE, an error is returned.
You can enter "TRUE" for the last ifs-expression… in your formula, followed by a default value for ifs-true…, to specify the result if all previous expressions (including ifs-expression and all instances of ifs-expression…) evaluate to FALSE.
Use IFS to make multiple comparisons
The table below shows a list of student grades.
A
B
C
1
Student
Score
Rating
2
4
Distinguished
3
Apprentice
Proficient
5
Incomplete
6
3.2
Proficient+
7
Novice
The table below returns the rating associated a score in the table above by using multiple ifs-expression… arguments.