Difference between revisions of "Formula Specification in Templates"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
=== Logical === | === Logical === | ||
{| class="wikitable sortable mw-collapsible | {| class="wikitable sortable mw-collapsible" | ||
!Name | !Name | ||
!Syntax, parameters | !Syntax, parameters | ||
Revision as of 11:23, 2 March 2023
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