Examples:

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: