ExcelFlux

VAR function

Estimates variance based on a sample.

Compatibility

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Recompute sample variance in a legacy workbook. VAR.S is the modern counterpart.

A worked example from the workbook

RowABC
6Period 1Period 2Period 3
7246
8333
9036
Record 1
=VAR(A7:C7)

Expected result4

See the inputs and instructions for all 3 examples

Syntax

VAR(number1,[number2],...)

Copyable formulas

English Excel · en-US
=VAR(A7:C7)
Turkish Excel · tr-TR
=VAR(A7:C7)

Compatibility function for older workbooks.

Worked examples

Recompute sample variance in a legacy workbook. VAR.S is the modern counterpart.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Period 1 Period 2 Period 3
7 2 4 6
8 3 3 3
9 0 3 6
Case Formula Expected result
Record 1 =VAR(A7:C7) 4
Record 2 =VAR(A8:C8) 0
Record 3 =VAR(A9:C9) 9
Microsoft Excel reference