Skip to content
ContentsFormula ReferenceUser guide
Formula Reference

=RMS — Root Mean Square

Formula
RMS = √( Σ xᵢ² / N )
Output
same unit as the input values
Bands
Any set of values
Standard / Source
General acoustics (no standard cited)
Access
Inline =function

What it does

Returns the root mean square of a set of values — the same result as Excel's =SQRT(SUMSQ(range)/COUNT(range)), which it is defined to match. It is meant for linear quantities sampled down a column, such as repeated vibration velocity or acceleration readings (mm/s, m/s²) or sound pressures in Pa.

ℹ️ Do not use it on decibel values: dB are already logarithmic, so squaring and averaging them has no physical meaning. Use =DBAVG for an energy average of levels.

Equation

xrms=1N∑ixi2x_{rms} = \sqrt{\frac{1}{N}\sum_i x_i^2}

Blank cells and text are skipped, not counted as zero. Signs do not matter (−3 and 3 contribute equally). An empty range returns #DIV/0!.

How to use it

=RMS(C5:C40)
=RMS(3, 4)

Worked example

=RMS(3, 4) → √((9 + 16) / 2) = 3.536

Source

Standard root-mean-square definition. No specific published standard is cited in the software.

Register interest

Tell us a little about you and we'll be in touch when Timbral is ready.