Formulas

Formulas are a special type of field input. As the name suggests, they are used in calculations based on different parameters. Formulas are used in pricing, discounts, payroll, balance sheets, etc.

Wherever the result is variable - calculable from the data based on some mathematical formula. css" rel="StyleSheet">OperandOperator.

We present in more detail below:

1. Operand

If the operand is a constant, it is simply typed in.

Fields from the program are used by placing them between the 'lojtrce'. .

The fields that can be used in formulas are defined using the formula. For example, for price formulas you can only use price fields, for salary formulas you can use salary fields, etc. Which fields you can use is specified in the instructions.

2. Operators

Operators are allowed mathematical symbols:

[ ] A parenthesis and a bracket must always be paired, otherwise the formula test returns an error (see Unbalanced (), missing )!). They are used to delimit conditions in logical expressions (see Use-logical-expressions-in-formulas) ( ) A round bracket and a round bracket must always be paired, otherwise the formula test returns an error (see Unbalanced conditions [], missing ]!). They are used to determine the order in which mathematical operations are performed.

Warning The formulae are calculated from left to right. The logical expression in a formula can be as deep as you like.