cellrms
Calculates the rms (the square root of the arithmetic mean of the squares) of the referenced cells.
Syntax
cellrms("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 a different window and/or pages are supported.
Examples
=cellrms("range", B3,B8,C12,D14)
=cellrms("list", B3,B8,C14)
Calculating the rms value from cell ranges B1 - B3:
=cellrms("range",b1,b3)
Comments
Blank cells and text (string type) cells within the selected range of cells will be ignored when doing the calculations.