VariancePercentexpects comparison of the same account type. When you compare two different account types, like Sales & Expense, the VariancePercent function performs the straight math without applying the logic of the account type. For example:
| Sales | Expense | Result |
|---|---|---|
-400 | 100 | -5. |
#missing is treated as zero (0), unless specified differently using ifnonnumber property.
#error is results in #error, unless specified differently using ifnonnumber property.
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%