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.
"range" is inclusive. For example, cellrms("range", b2, b10) returns the rms value of all cells between the cells b2 and b10.
"range" always has an equal number of arguments: 2, 4, 6, and so on.
"list"
The operation is performed on each cell math reference that follows. Every listed cell will be added.
"list" can have any number of arguments.
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

Get the rms value over the cell ranges B3 - B8 and C12 - D14:
=cellrms("range", B3,B8,C12,D14)
Get the rms value of the cells B3, B8, and C14:
=cellrms("list", B3,B8,C14)

Calculating the rms value from cell ranges B1 - B3:

Figure 1.


The Templex expression in cell B4 is:
=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.