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 |