|
|
|
VariancePercent(Actual: Number, Budget: Number): Number
Calculates the variance percent of two numbers as follows,
VariancePercent(Actual, Budget) = (Budget - Actual)/Budget * 100, with variance sign matching.
VariancePercent function syntax has these named arguments:
Parameter |
Description |
Actual |
Required. Actual amount to be calculated as a variance percent of the Budget. |
Budget |
Required. Budget Amount to calculate Actual as a variance percent of. |
|
|
|
