Examples
VariancePercent
accepts, cell, column, or row references only. See Row, Column, or Cell Reference Arguments.
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: