VARA

The VAR function estimates the variance for a sample of data. Variance provides a general idea of the spread of data. Unlike the VAR function, the VARA function evaluates text values and logicals in references. Text is evaluated as zero, TRUE is evaluated as 1, and FALSE is evaluated as zero. In the example shown, the formula in F5 is: Note that the VAR function ignores the "NA" text in C8, while VARA includes this in the variance estimate as zero. Like VAR, VARA also evaluates logical values, and text representations of numbers when they are hardcoded directly into the function as arguments. The table below summarizes the variation functions available in Excel.