Case function

Contents > Functions reference (alphabetical list) > Logical functions > Case function

Case function

Format


Case(test1;result1{;test2;result2;...;defaultResult})

Parameters

test - any text or numeric expression.

result - result corresponding to the expression.

Parameters in curly braces { } are optional.

Data type returned

text, number, date, time, timestamp, container

Description

Returns one of several possible results based on a series of tests.

The Case function 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 evaluate to True, the Case function returns the value specified for defaultResult. If no default result is supplied, the Case function returns an "empty" result.

Examples

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 10, when the Shipment Method field contains Air.

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Logical functions > Case function