Microsoft Office Tutorials and References

In Depth Information

**Working with Functions**

Table 3-3

Common Functions and Their Use

Function

Returns

AVERAGE(
number1
,number2,. . .
)

The average of the numbers in the cells listed

in the arguments.

COUNT(
value1
,value2,. . .
)

The number of cells that contain the numbers

listed in the arguments.

MAX(
number1
,number2,. . .
)

The largest value in the cells listed in the

arguments.

MIN(
number1
,number2,. . .
)

The smallest value in the cells listed in the

arguments.

PRODUCT(
number1
,number2,. . .
)

The product of multiplying the cells listed in

the arguments.

STDEV(
number1
,number2,. . .
)

An estimate of standard deviation based on

the sample cells listed in the argument.

STDEVP(
number1
,number2,. . .
)

An estimate of standard deviation based on

the entire sample cells listed in the arguments.

SUM(
number1
,number2,. . .
)

The total of the numbers in the arguments.

VAR(
number1
,number2,. . .
)

An estimate of the variance based on the

sample cells listed in the arguments.

VARP(
number1
,number2,. . .
)

A variance calculation based on all cells

listed in the arguments.

Figure 3-12:

The Insert

Function

dialog box.