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:

                      Year Product Market

                      Actual   Budget VariancePercent

                    ======== ======== ========

Sales(Income)       400,855  373,080     7%

COGS (Expense)      179,336  158,940   -13%