# 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.