Requirements & Installation

• Pro Version

In its simplest form, the SWITCH function says:

switch(Value to switch, Value to match1, to return if there's a match1, Value to return if there's no match))

Where you can evaluate up to 126 matching values and results.

E.g:

switch([number-a],1,"Sunday",2,"Monday",3,"Tuesday","No match")

• Value to switch? Name [number-a]
• if [number-a] = 1 then value = Sunday
• if [number-a] = 2 then value = Monday
• if [number-a] = 3 then value = Tuesday
• if [number-a] = 4 or if [number-a] != 1,2,3 then value = No match