Term
|
Definition
| Find the sum of all the numbers in the cell range. |
|
|
Term
| SUMIF({cell range}, {condition}, {sum range}) |
|
Definition
| Find the sum of all the numbers in the cell range whose corresponding sum range number satisfies the condition. |
|
|
Term
| SUMPRODUCT({cell range 1}, {cell range 2}, ... {cell range n}) |
|
Definition
| Find the sum of the products of the corresponding items in each of the cell ranges. |
|
|
Term
SUMSQ(number 1, number 2, ... number n)
SUMSQ({cell range}) |
|
Definition
| Find the sum of the squares of the numbers. |
|
|
Term
| ROUND (number, decimal places) |
|
Definition
| Round a number off to a number of decimal places. |
|
|
Term
| ROUNDDOWN(number, decimal places) |
|
Definition
| Round a number down a number of decimal places (if the number is positive) or round a number up a number of decimal places (if the number is negative). |
|
|
Term
| ROUNDUP(number, decimal places) |
|
Definition
| Round a number up a number of decimal places (if the number is positive) or round a number down a number of decimal places (if the number is negative). |
|
|
Term
|
Definition
| Round a number down to the nearest integer. |
|
|
Term
TRUNC(number, decimal places)
[-1 decimal places will truncate it to the tens digit, etc.] |
|
Definition
| Truncate a number to a number of decimal places. |
|
|
Term
| QUOTIENT (dividend, divisor) |
|
Definition
| Find the integer portion of the quotient of a division operation. |
|
|
Term
|
Definition
| Find the remainder of a division operation. |
|
|
Term
|
Definition
| Find a power of a number. |
|
|
Term
|
Definition
| Find the square root of a number. |
|
|
Term
|
Definition
| Get a random number smaller than one but larger than or equal to zero. |
|
|
Term
|
Definition
| Get the absolute value of a number. |
|
|
Term
FREQUENCY({cell range}, {range range})
[Array function.] |
|
Definition
| Create a frequency distribution table using the data in a cell range and the ranges in a range range. |
|
|
