The Excel VAR function estimates the variance of a sample of data. If data represents the entire population, use the VARP function or the newer VAR.P function. VAR ignores text values and logicals in references.
Get variation of a sample
=VAR (number1, [number2], ...)
number1 - First number or reference.
number2 - [optional] Second number or reference.
The VAR function estimates the variance for a sample of data. Variance provides a general idea of the spread of data. In the example shown, the formula in F4 is:
VAR ignores text and logicals passed into as cell references. For example, VAR will ignore FALSE when it appears in a range like A1:A10. However, VAR will evaluate logical values, and text representations of numbers hardcoded directly as arguments.