DVARP(arg1, arg2, arg3) → { number | string | boolean }

Calculates variance based on the entire population of selected database entries.


Name Type Description
arg1 ApiRange

Is the range of cells that makes up the list or database. A database is a list of related data.

arg2 number

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

arg3 string

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.


number | string | boolean