Formula structure

ClearLines formulas consist of the following elements.

  • Operators

    • Arithmetic - +, -, *, /, ^

    • Conditions - <, <=, ==, <>, >=, >

    • Assignment - “=”

  • Functions - like ABS, IF, OPEN, SUM, ...

    • Parameters - used within functions

  • Widget content references - like #cell1 - accessing widgets content

  • Values - like texts, numbers, dates, images, ...

Remarks

  • It is possible to nest multiple functions as function parameters. Example

    • AND(OR(NOT(#cell1 > 5); #cell2 < 5); ...

  • Before a parameter is used for a function, it is completely evaluated.