2.5.3 Function Token Table
This section specifies the list of functions that can be called from a formula expression. The function display name, ABNF func-name and function type are provided for each function.
Display name |
ABNF func-name |
Type |
---|---|---|
ABS |
||
ACOS |
PtgFunc |
|
_ADD |
PtgFunc |
|
AND |
PtgFunc |
|
ANG360 |
PtgFunc |
|
ASIN |
PtgFunc |
|
ATAN |
PtgFunc |
|
ATAN2 |
PtgFunc |
|
BITAND |
PtgFunc |
|
BITNOT |
PtgFunc |
|
BITOR |
PtgFunc |
|
BITXOR |
PtgFunc |
|
BLEND |
PtgFunc |
|
BOUND |
||
CEILING |
PtgFuncVar |
|
CELLISTHEMED |
PtgFunc |
|
CHAR |
PtgFunc |
|
COS |
PtgFunc |
|
_CAT |
PtgFunc |
|
COSH |
PtgFunc |
|
CY |
PtgFunc |
|
DATE |
PtgFunc |
|
DATETIME |
PtgFuncVar |
|
DATEVALUE |
PtgFuncVar |
|
DAY |
PtgFuncVar |
|
DAYOFYEAR |
PtgFuncVar |
|
DEG |
PtgFunc |
|
_DIV |
PtgFunc |
|
_EEQ |
PtgFunc |
|
_EGE |
PtgFunc |
|
_EGT |
PtgFunc |
|
_ELE |
PtgFunc |
|
_ELT |
PtgFunc |
|
_ENE |
PtgFunc |
|
_FEQ |
PtgFunc |
|
_FGE |
PtgFunc |
|
_FGT |
PtgFunc |
|
FIND |
PtgFuncVar |
|
_FLE |
PtgFunc |
|
FLOOR |
PtgFuncVar |
|
_FLT |
PtgFunc |
|
_FNE |
PtgFunc |
|
FORMATEX |
PtgFunc |
|
HOUR |
PtgFuncVar |
|
HSL |
PtgFunc |
|
HUE |
PtgFunc |
|
HUEDIFF |
PtgFunc |
|
INDEX |
PtgFuncVar |
|
INT |
PtgFunc |
|
INTERSECTX |
PtgFunc |
|
INTERSECTY |
PtgFunc |
|
INTUP |
PtgFunc |
|
ISERR |
PtgFunc |
|
ISERRNA |
PtgFunc |
|
ISSERROR |
PtgFunc |
|
ISERRVALUE |
PtgFunc |
|
LEFT |
PtgFuncVar |
|
LEN |
PtgFunc |
|
LN |
PtgFunc |
|
LOG10 |
PtgFunc |
|
LOOKUP |
PtgFuncVar |
|
LOWER |
PtgFunc |
|
LUM |
PtgFunc |
|
LUMDIFF |
PtgFunc |
|
MAGNITUDE |
PtgFunc |
|
MAX |
PtgFuncVar |
|
MID |
PtgFunc |
|
MIN |
PtgFuncVar |
|
MINUTE |
PtgFuncVar |
|
MODULUS |
PtgFunc |
|
MONTH |
PtgFuncVar |
|
MSOSHADE |
PtgFunc |
|
MSOTINT |
PtgFunc |
|
_MUL |
PtgFunc |
|
NOT |
PtgFunc |
|
NOW |
PtgFunc |
|
OR |
PtgFunc |
|
_PCT |
PtgFunc |
|
PI |
PtgFunc |
|
POW |
PtgFunc |
|
PNT |
PtgFunc |
|
RAD |
PtgFunc |
|
RAND |
PtgFunc |
|
REPLACE |
PtgFunc |
|
RGB |
PtgFunc |
|
RIGHT |
PtgFuncVar |
|
ROUND |
PtgFunc |
|
SAT |
PtgFunc |
|
SATDIFF |
PtgFunc |
|
SECOND |
PtgFuncVar |
|
SETATREF |
PtgFuncVar |
|
SETATREFEVAL |
PtgFunc |
|
SETATREFEXPR |
PtgFuncVar |
|
SHADE |
PtgFunc |
|
SHAPETEXT |
PtgFuncVar |
|
SIGN |
PtgFuncVar |
|
SIN |
PtgFunc |
|
SINH |
PtgFunc |
|
SQRT |
PtgFunc |
|
STRSAME |
PtgFuncVar |
|
STRSAMEEX |
PtgFunc |
|
_SUB |
PtgFunc |
|
SUBSTITUTE |
PtgFuncVar |
|
SUM |
PtgFuncVar |
|
TAN |
PtgFunc |
|
TANH |
PtgFunc |
|
TEXTHEIGHT |
PtgFunc |
|
TEXTWIDTH |
PtgFunc |
|
TIME |
PtgFunc |
|
TIMEVALUE |
PtgFuncVar |
|
TINT |
PtgFunc |
|
TONE |
PtgFunc |
|
TRIM |
PtgFunc |
|
TRUNC |
PtgFunc |
|
_UMINUS |
PtgFunc |
|
_UPLUS |
PtgFunc |
|
UPPER |
PtgFunc |
|
WEEKDAY |
PtgFuncVar |
|
YEAR |
PtgFuncVar |