Difference between revisions of "Formula Specification in Templates"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
!Syntax, parameters | !Syntax, parameters | ||
!Description | !Description | ||
!Example | !''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 ])'' | ||
| | | | ||
| | | | ||
Revision as of 12:22, 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