INCASE returns a valid switch value based on logical expressions

Syntax

INCASE(LogExpr,[ElseIf],LogExpr,[Else],Expr)

Arguments

...

is equivalent to the algorithm:

    If A<5 Then
    B=1
   ElseIf A>9 Then
    B=3
   Else
    B=2
   EndIf

A number of ELSEIF, LogExp can be provided in sequence in INCASE() to simulate a Select Case function.

...