Introduction

The VAR formula allows you to Calculate the variance of two values. The Variance can be expressed as an absolute number or as a relative value.

Syntax

VAR

(Parameter0 - Parameter1) or in the case of a relative variance (Parameter0 - Parameter1) / Parameter1

Depending on the Display Value of the Pick List the variance can be displayed in different ways:

• Variance (Default): Variance value will be displayed as (Parameter0 - Parameter 1) or (Parameter0 - Parameter 1) / Parameter 1 (in case of relative variance)
• Base: Variance value will be displayed as Parameter 0
• Reference: Variance value will be displayed as Parameter 1

These options are available from version 4.2.

• Starting form version 4.3.1 Better/Worse variance representation can be used to display positive variance with positive sign and negative variance with minus sign.

Example 1 - Variance (Default):

Example 2 - Better/worse:

See also

How_can_I_apply_conditional_formatting?