Formula Builder

Operand

Description

/

Divide by

*

Multiply by

-

Subtract from

+

Add to

C

Delete

\

Integer division -  You can also enter operand by using the shortcut Alt Gr + Q.

|

Remainder in integer division -  You can also enter operand by using the shortcut Alt Gr + W.

( )

Round brackets - Use them to define precedence of operations. There must always be an equal number of opening and closing round brackets. otherwise an error is returned (see Opening or closing round bracket missing!).

#

You must put a hash sign in front and after each variable.

 >

Greater than - used in conditional statements.

< 

Less than - used in conditional statements.

=

Equal to - used in conditional statements.

[ ]  Use square brackets in conditional statements for

"If Than": Use then in conditional statements when for example Condition 1 is fulfilled than

Value 1 otherwise use Else.

Square brackets - Use them to define precedence of operations. There must always be an equal number of opening and closing round brackets. Otherwise an error is returned (for more information see Opening or closing square bracket missing!). For more information see Using Conditional Statements in Formulas).

Let us take a look at the Round function (;). Use this variable to set number of decimal places for rounding.