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

aaa

Text

aaa

Statistical

vvv