If … then … else (? :)

One value or another, depending on a test.

Syntax

test ? then : else

Result

Whichever value the test chooses.

Examples

In the example drawing:

Notes

Only the value chosen is worked out. To choose from more than two, put the later choice in brackets, as in L>600?3:(L>400?2:1): without them, a?b:c?d:e is read as (a?b:c)?d:e.

See also: SWITCH, < <= > >=, && || ^.

More expressions