Formula Specification in Templates
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
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| ABS | |||
| ACOS | |||
| ACOT | |||
| ASIN | |||
| ATAN | |||
| COS | |||
| SIN | |||
| COT | |||
| TAN | |||
| EXP | |||
| LN | |||
| LOG | |||
| LOG10 | |||
| PI | |||
| POWER | |||
| SQR | |||
| SQRT | |||
| TAN |
vvv
Text
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| CONCAT |
vvv
Statistical
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| AVERAGE | |||
| MAX | |||
| MIN |
vvv
Matrix
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| LINEARTREND | |||
| LINEARTRENDANDPOINTS | |||
| LINEARTRENDSC | |||
| LINEARTRENDSCANDPOINTS | |||
| LINEARTRENDTOPOINTS | |||
| SEMICIRCELTOPOINTS |
vvv