Examples:

The VariancePercent function accepts, cell, column, or row references only.

SyntaxExample

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 Product Market 
                      Actual   Budget VariancePercent 
                    ======== ======== ======== 
Sales(Income)       400,855  373,080     7%
COGS (Expense)      179,336  158,940   -13%