ABS(number) |
Returns
the absolute value of number. Number
is usually a cell reference, as in ABS(B3),
or the result of a calculation such as
ABS(D4:D23) |
AVERAGE(range) |
Calculates
the average value of the cells in range
by determining the sum of all the cells
and then dividing the result by the nuber
of all cells in the range. |
COUNT(range) |
Returns
the number of cells in the range. |
MAXIMUM(range) |
Returns
the largest value in range. |
MINIMUM(range) |
Returns
the smallest value in range. |
ROUND(number,
decimal places)) |
Rounds
off the number
to the specified number of decimal
places. |
SUM(range) |
Adds
the values of all the cells in the
specified range. |
TODAY() |
Returns
the current date. No arguments are
required. |