Formula, syntax and examples for conditions

Tool(s): Label Style, defining formula + Define Cell, formula

Syntax for conditions:

_IF_(<condition>)<Statement>_ELSE_<Statement> ...

Note: Text must be enclosed in double quotation marks ‘’ ‘’.

Note: You can use wildcards (*,?).

Some examples:

_IF_(Material=“B*“)Volume_ELSE_Area

If the name of the material starts with the letter ”B”, the volume is calculated. Otherwise, the area is calculated.

_IF_(Height>2)Area_ELSE__IF_(Height>1)Area*0.5_ELSE_0

If the height > 2, the area is used for the calculation. If the height >1, the area*0.5 is used. If the height &lt;1, 0 is returned.

_IF_(Volume>0)"Text 1"_ELSE_"Text 2"

If the volume is greater than 0, use Text 1. Otherwise, use Text 2.