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.
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.