Examples

The Variance function accepts cell, column, or row references only. For more information, see Row, Column, or Cell Reference Arguments.

SyntaxExample

Sample syntax referencing a column:

Var ([A], [B])

Sample syntax referencing a row:

Var ([3], [4])

Sample syntax referencing a cell:

Var (Cell [3,A], [3,B])

In this example, the variance between column A (Actual) and column B (Budget) is calculated as follows: 

Var([A],[B])

This example produces the following report: 

                       		Year   Product Market 
                      Actual   Budget Variance 
                    ======== ======== ======== 
Sales(Income)       400,855  373,080    27,775 
COGS (Expense)      179,336  158,940   -20,396