Skip to Content

VAR

Estimates variance based on a sample (ignores logical values and text). Replaced by VAR.S.

Syntax

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

Parameters

  • number1: Required. The first number argument corresponding to a sample of a population
  • number2: Optional. Additional number arguments, up to 255

Example

=VAR(A1:A10)
Returns: NumberSince: Excel 2003