Formula structure

ClearLines formulas consist of the following elements.

• Operators

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

  • Conditions: <, <=, ==, <>, >=, >

  • Text concatenation: &

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