Map and Table Calculation
Functional overview of operators and functions
Operators
Functions
Operators
Arithmetic operators
+
-
*
/
^
MOD
DIV
Logical operators
AND
OR
XOR
NOT
Relational operators
Functions
Aggregate functions
AGGAVG
AGGCNT
AGGMIN
AGGMED
AGGMAX
AGGPRD
AGGSTD
AGGSUM
Angular functions
DEGRAD
RADDEG
Classify function
CLFY
Color functions
CLRRED
CLRGREEN
CLRBLUE
CLRYELLOW
CLRMAGENTA
CLRCYAN
CLRGREY
CLRHUE
CLRSAT
CLRINTENS
COLOR
COLORHSI
MAPCOLOR
RPRCOLOR
Conditional IFF function
IFF
Coordinate conversion functions
DMS
DEGREE
LAT
LON
SEC
Coordinate functions
COORD
CRDX
CRDY
DIST
DIST2
MAPCOL
MAPCRD
MAPROW
MAPVALUE
MAXCRDX
MAXCRDY
MINCRDX
MINCRDY
RASVALUE
TRANSFORM
Data property functions
MAPMAX
MAPMIN
MAPCOLS
MAPROWS
PIXAREA
PIXSIZE
TBLCOLS
TBLRECS
TBLVALUE
Exponential functions
EXP
HYP
POW
SQ
SQRT
Laws of exponents
Hyperbolic functions
SINH
COSH
TANH
Inrange function
INRANGE
Logarithmic functions
LOG
LN
Laws of logarithms
NDVI function
NDVI
Point functions
PNTCRD
PNTNR
PNTVAL
Predefined values
EXP(1)
FALSE
PI
PI2
PIDIV2
PIDIV4
TRUE
Predefined variables
%C
%D
%K
%L
%P
%R
%X
%Y
Random functions
RND
Rounding functions
CEIL
FLOOR
ROUND
Sign functions
ABS
NEG or -(a)
SGN
Statistical functions
AVG
CHISQUARE
CNT
CORR
COVAR or COV
CUM
MAX
MIN
STD or STDEV
STERR
SUM
TTEST
VAR
String conversion functions
CODE
NAME
STRING
VALUE
String functions
IN
INMASK
LEFT
LENGTH
RIGHT
STRLE
STRLT
STRGE
STRGT
STRPOS
SUB
Trigonometric functions
SIN
COS
TAN
ASIN
ACOS
ATAN
ATAN2
Undefined functions
IFNOTUNDEF
IFUNDEF
ISUNDEF
Assigning undefined values