Name
VARA
Synopsis
Use
VARA to find the
variance in a list of values based upon a sample. If a value
specified contains the logical value TRUE
it is
evaluated as 1. If a value contains text or the logical value
FALSE
it is evaluated as 0.
To Calculate
=VARA(Value1
,Value2
, ...)
There must be at least one Value
argument
specified for this function.
Example
Figure 15-50 illustrates how to use VARA to find the variance of a list of values. Since the list includes two logical values, those values are evaluated as part of the variance.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.