VAR.S Function Explained

The VAR.S Function in Microsoft Excel calculates the sample variance of a supplied set of values. It takes up to 255 arguments, which can be numbers, cell references, or ranges. It returns the sample variance of the supplied values, which is a measure of how spread out the values are from the mean.

VAR.S Function Syntax

VAR.S(number1, [number2], ...)

  • number1: The first number, cell reference, or range for which you want to calculate the variance.
  • number2: (optional) Additional numbers, cell references, or ranges for which you want to calculate the variance.