result - result corresponding to the expression.
Case evaluates each test expression in order, and when a True expression is found, returns the value specified in
result for that expression.
You can include a default result at the end of the parameter list. If none of the expressions evaluated return True, the Case function returns the value specified for
defaultResult. If no default result is supplied,
Case returns an empty result.
Case(Score >= 90;“Excellent”;Score > 50;“Satisfactory”;“Needs Improvement”) displays
Excellent when the score is 90 or above,
Satisfactory when the score is between 50 and 90, and
Needs Improvement for any other score.
Case(Shipment Method=”Ground”;2;Shipment Method=”Air”;10) returns
2 when the Shipment Method field contains Ground, and returns
10 when the Shipment Method field contains Air.