The VariancePercent function accepts, cell, column, or row references only.
| Syntax | Example |
|---|---|
Sample syntax referencing a column | VarPer ([A], [B]) |
Sample syntax referencing a row | VarPer ([3], [4]) |
Sample syntax referencing a cell | VarPer (Cell [3,A], [3,B]) |
In this example, the VariancePercent between column A (Actual) and column B (Budget) is calculated as follows:
VarPer([A],[B])
This example produces the following report:
Year Actual | Product Budget | Market VariancePercent | |
|---|---|---|---|
Sales(Income) | 400,855 | 373,080 | 7% |
COGS (Expense) | 179,336 | 158,940 | -13% |