Versions Compared

Version Old Version 6 New Version 7
Changes made by

Nadica Gaber

Nadica Gaber

Saved on

Key

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

Introduction

The 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.

The syntax of this formula is: (Parameter0 - Parameter1) or in the case of a relative variance (Parameter0 - Parameter1) / Parameter1

CONTENT

Table of Contents

From the DisplayValueof dropdown Display Value of drop down 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
  •  Better/Worse variance representation can be used to display positive variance with positive sign and negative variance with minus sign.

 

Image RemovedImage Added

Example 

See also

How_can_I_apply_conditional_formatting?