The Variance function accepts cell, column, or row references only.
Syntax | Example |
---|---|
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:
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