Formula Specification in Templates
Jump to navigation
Jump to search
List of formula specification using in Templates.
Categories of functions:
Logical
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| AND | AND(Boolean1;Boolean2; ... ) | Returns TRUE if all of its arguments are TRUE | AND(3=3;2=2) ⇒ TRUE |
| OR | OR(Boolean1;Boolean2; ... ) | Returns TRUE if any of its arguments are TRUE | OR(3=4;2=3) ⇒ FALSE |
| TRUE | TRUE() | IF(TRUE();1;2) ⇒ 1 | |
| FALSE | FALSE() | IF(FALSE();1;2) ⇒ 2 | |
| IF | IF(Test;Then;Else) | ||
| IFS | IFS(Test1;Then1;Test2;Then2; ... ;Else) | ||
| NOT | NOT(Boolean) | ||
| SWITCH | SWITCH(Switch;Case1;Result1;Case2;Result2; ... ;[ Else ]) |
Mathematical
aaa
Text
aaa
Statistical
vvv