next up previous contents index
Next: ROUND Up: A Function Reference Previous: RIGHT

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:

displaymath16328

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


next up previous contents index
Next: ROUND Up: A Function Reference Previous: RIGHT

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999