Term
|
Definition
| Counts the total number and text cells |
|
|
Term
|
Definition
|
|
Term
| =countif(range,parameter) |
|
Definition
| Counts the number of cells that find the parameter in the range |
|
|
Term
|
Definition
| generates random numbers in the cell |
|
|
Term
|
Definition
| =if(logical_test, value if true, value if false) |
|
|
Term
|
Definition
v/h lookup(lookup value table array, column, index number, [range lookup])
(false gives exact numbers)
(true gives closest number) |
|
|
Term
|
Definition
| if(isna(=HLOOKUP(A20,A20:B22,3,false),"not found",hlookup(a20,a20:b22,3,false) |
|
|
Term
|
Definition
| If B3 contains the formula =B2+B3, then B3 contains a circular reference. A formula refers—either directly or indirectly—to the cell in which the formula is stored. |
|
|
Term
| recalculate: automatic manual |
|
Definition
few calculations lots of calculations
pres F9 to recalculate |
|
|
Term
|
Definition
| rounds number to nearest interger |
|
|
