Skip to main content

Operators are used to process or combine formula contents.

OperatorDescription

+

Combines text or adds numerical values ("Text1" + "Text2")

-, *, /, +

For the calculation of numerical values

=

Is equal for the matching of conditions (x = y)

#

Not equal for the reverse comparison of conditions (x # y)

>

Greater than... "x > y" (greater than or equal to: > =)

<

Less than... "x < y" (less than or equal to: <=)

;

Semicolon for separating parameters

" "

Apostrophe before and after entered text ("abcde")

( )

Brackets for structuring the components of a formula

:

Ternary operator (separator between then and else parameters)

?

Question mark before and after entered times (?00:00:00?) or ternary operator (condition)

!

Exclamation mark before and after an entered date (!00.00.0000!)

{ }

Indicates placeholders in service functions (placeholders do not necessarily have to be filled)

Char(13)

Sets a carriage return

Char(9)

Sets a tab