VARA

Definition: The VARA function in Excel is used to find the variance of a range of data that contains text or logical values.

Syntax: ==VARA(number1, [number2], …).

Situation: This formula is appropriate in situations where you need to find the variance of a range of data that contains text or logical values.

Example: If you have a range of data A1:A5 that contains the numbers 1, 2, “three”, 4, and TRUE, you would use the formula =VARA(A1:A5). This would return a value of 1.7, which is the variance of the data in the range.