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.
Search JabSto ::

Custom Search