Examples
The following section provides examples of the various functions.
Arithmetic Functions
The arithmetic syntax that can be entered in the formula fields are described in the following table.
| Syntax | Examples |
|---|---|
| Comparison | Expression =, <=, =<, >=, =>, <> Expression |
| Expression | Term { + Term | - Term | OR Term } |
| Term | Factor { * | / | AND | XOR | DIV | MOD Factor} |
| Factor | [NOT] number | (Comparison) | Function | ^ Factor [!] |
| Number | [-|+] Digit {Digit} [, {Digit}] |
| Function | Character {Character} [(Comparison{; Comparison} )] |
| Character | A | B | C | D ... W | X | Y | Z |
| Digit | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| := | is defined as |
| { ... } | The expression in curly brackets can be repeat as often as possible. |
| [ ... ] | The expression in square brackets can be omitted. |
| | | Alternative selection, e.g., a number can be a 0, 1, 2, ... 8 or 9 |
Terminal Symbols, Functions, and Constants
The following list contains terminal symbols, functions, and constants as well as some examples.
- Terminal Symbols
- Digits, characters, and the marks '(', ')', '+', '-', '*', '/', '=', '>', '<', '^', '!', ';'
- Expressions 'AND', 'OR', 'XOR', 'NOT', 'DIV', 'MOD' are terminal symbols
- Internal Functions
- SIN(), ARCSIN(), COS(), ARCCOS(), TAN(), COT(), IF (boolean expression is true or false)
- String Functions
- CONCAT(), MID(), LEFT(), RIGHT(), for example:
- CONCAT(String1; String2; String3; ...)
- MID(String; StartPos; NoOfCharacters)
- RIGHT(String; NoOfCharacters)
- LEFT(String; NoOfCharacters)
- CONCAT(), MID(), LEFT(), RIGHT(), for example:
- Dynamic User Functions
- Square meter calculation: %1*%2
- Circular area calculation: %1^2 * PI (placeholder = %1 must be the radius)
- Constants
- PI as a constant for the number PI (3.1415...)
- Examples
- COS(15) * 10^3 = 965.9258
- 16 MOD 3 = is 1
- (15 * 3) > (60 / 10) = 1 (1 is equal to yes or true)
- (15 * 3) < (60 / 10) = 0 (0 is equal to no or false)
Feedback
Submit feedback for this page .