RMS(<List>)

 

Description

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

 

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

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.