Formula Engine Reference Guide
 

 

Back to Class Index

 

RMS(argumentlist)

Description
Returns the square root of the mean of squares of its arguments. Blank cells and cells containing strings are not counted.
 
Parameters
argumentlist

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