Excel Functions

Excel VARP Function

Pinterest LinkedIn Tumblr

VARP function calculates the variance of an entire population of data. If data represents a sample, use the VAR function or the newer VAR.S function. VARP ignores text values and logicals in references.

Purpose of Excel VARP Function

Get variation of a population.

Return value

Computed variance.


=VARA (number1, [number2], …)


number1First number or reference.Mandatory
number2Second number or reference. Optional

Usage notes

  • VARP assumes data is an entire population.
  • If data represents a sample, use VAR or VAR.S
  • VARP only evaluates numbers in references, ignoring empty cells, text, and logical values like TRUE or FALSE.
  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • Arguments can be hard-coded values instead of references.
  • To evaluate logical values and/or text in references, use the VARA function.


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment