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)
  • 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 .