Versions Compared

Version Old Version 3 New Version 4
Changes made by

Migration (Unlicensed)

Migration (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

The VAR Variance 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

The syntax of this formula is: (Parameter0 - Parameter1) or in the case of a relative variance (Parameter0 - Parameter1) / Parameter1Depending on the Display Value of the Pick List the variance can be displayed in different ways

CONTENT

Table of Contents

From the DisplayValueof dropdown list, the user has option to choose between the following:

  • 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
  •  Better/Worse variance representation can be used to display positive variance with positive sign and negative variance with minus sign.

Image Removed

Example 1 - Variance (Default):

Image Removed

Example 2 - Better/worse:

Image Removed

 

Image Added

Example 

Image Added

See also

How_can_I_apply_conditional_formatting?

CONTENT

toc