cellmin
Returns the minimum value of the referenced cells.
Syntax
cellmin("option", cellref1, cellref2...cellrefn)
Argument
- "option"
- The "option" argument can be one of two types,
"range" or "list".
- "range"
- Each pair of cell references define a cell range.
- "list"
- The operation is performed on each cell math reference that follows. Every listed cell will be added.
- cellref1
- The cell reference parameters must be legal references to TableView cells. Both relative cell references (b2, c26, e45,...) to cells in the same table and absolute cell references (p1w1_b2, p21w4_c26, ...) to cells in tables in different window and/or pages are supported.
Examples
=cellmin("range", B3,B8,C12,D14)
=cellmin("list", B3,B8,C14)
Comments
Blank cells and text (string type) cells within the selected range of cells will be ignored when doing the calculations.