Term
|
Definition
| Find the maximum value in a range of cells. |
|
|
Term
|
Definition
| Find the minimum value in a range of cells. |
|
|
Term
|
Definition
| Find the nth largest value in a cell range. |
|
|
Term
|
Definition
| Find the nth smallest value in a cell range. |
|
|
Term
| RANK({number}, {cell range}, {order}) [order = 0/null -> desc, else ->asc] |
|
Definition
| Find the rank of a number within a cell range. |
|
|
Term
|
Definition
| Find the number of cells which contain numerical data in a cell range. |
|
|
Term
| COUNTIF({cell range}, {condition}) |
|
Definition
| Find the number of cells within a range of cells satisfying a certain condition. |
|
|
Term
|
Definition
| Find the number of cells which either are empty or contain numerical data in a cell range. |
|
|
Term
|
Definition
| Find the number of cells which are empty in a cell range. |
|
|
Term
|
Definition
| Find the mean a of range of cells. |
|
|
Term
|
Definition
| Find the mode of a range of cells. |
|
|
