Spreadsheet Functions

The following table lists Spreadsheet Functions:

Function Meaning
ABS(exp)  Calculates the absolute value
ACOS( exp)  Calculates the arc cosine
ASIN( exp)  Calculates the arc sine
ATAN( exp) Calculates the arc tangent
ATAN2( exp1,exp2)  Calculates the arc tangent using projections
COS( exp)  Calculates the trigonometric cosine
EXP( exp) Calculates the exponent
IFF(logical,value_true,value_false) Assigns different values if condition is true or false
INT( exp)  Calculates the whole part (integer) of a number
LN( exp) Calculates the natural logarithm
LOG( exp)  Calculates the decimal logarithm
MATRA( mat1) Calculates the transposed matrix
MAX( exp1[,exp2[, ...,expn]]) Finds the highest value
MIN( exp1[,exp2[, ...,expn]]) Finds the lowest value
MTAVG( exp1[,exp2[, ...,expn]]) Calculates the arithmetic mean
MTDIV( exp1,exp2)  Calculates the integer of quotient
MTMOD( exp1,exp2)  Calculates the remainder resulting from a division
MTSUM( exp1[,exp2[, ...,expn]]) Calculates the summation
SIGN( exp) Calculates the algebraic sign
SIN( exp) Calculates the trigonometric sine
SQRT( exp)  Calculates the square root
TAN( exp) Calculates the trigonometric tangent