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 |