RMS

Syntax: RMS(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

RMS returns the square root of the mean of squares of its arguments. Blank cells and cells containing strings are not counted. The function is given by:

$$\sqrt{\frac{1}{N} \sum_{i=1}^N a_i^2}$$

Examples:

RMS(2, 2, 3, 6) = 3.6400549

RMS(H8..H11) = 97.3413, where H8..H11 are 96, 97, '', and 99

RMS(D1..D6) = 48.72029, where D1..D6 = 4, 56, 33, 100, 0, and -1

Excel function: N/A