Microsoft Office Tutorials and References
In Depth Information
Session 2.1
Figure 2-2
Math and Statistical functions
Function
Description
AVERAGE( number1 , [ number2 , number3 , ...])
Calculates the average of a collection of numbers, where
number1 , number2 , and so forth are numeric values or
cell references
COUNT( value1 , [ value2 , value3 , ...])
Calculates the total number of values, where value1 ,
value2 , and so forth are numeric values, text entries, or
cell references
MAX( number 1, [ number2 , number3 , ...])
Calculates the maximum of a collection of numbers, where
number1 , number2 , and so forth are either numeric values
or cell references
MEDIAN( number1 , [ number2 , number3 , ...])
Calculates the median, or the number in the middle, of a
collection of numbers, where number1 , number2 , and so
forth are either numeric values or cell references
MIN( number1 , [ number2 , number3 , ...])
Calculates the minimum of a collection of numbers, where
number1 , number2 , and so forth are either numeric values
or cell references
ROUND( number , num_digits )
Rounds a number to a specified number of digits, where
number is the number you want to round and num_digits
specifies the number of digits to which you want to round
the number
SUM( number1 , [ number2 , number3 , ...])
Calculates the sum of a collection of numbers, where
number1 , number2 , and so forth are either numeric values
or cell references
For example, the AVERAGE function calculates the average value of a collection of
numbers. The syntax of this function is AVERAGE( number1, [ number2 , …]). When you
enter the arguments (number1, number2) , you can enter these numbers directly into the
function, as in AVERAGE(3, 2, 5, 8), or you can enter the references to the worksheet cells
that contain those numbers, as in AVERAGE(A1:A4). You can also enter a function as part
of a larger formula. For example, the formula =MAX(A1:A100)/100 calculates the maxi-
mum value in the cell range A1:A100 and then divides that number by 100. You can
include, or “nest,” one function within another. For example, in the formula
=ROUND(AVERAGE(A1:A100),1) , the first argument in the ROUND function uses the
value calculated by the AVERAGE function; the second argument is a constant. The result
is a formula that calculates the average value of the numbers in the range A1:A100,
rounding that value to the first decimal place.
In the previous tutorial, you calculated totals using the AutoSum button on the
Standard toolbar. Although using the AutoSum feature is a quick and convenient way to
calculate a value, it is only one way to perform this calculation in Excel. To determine the
totals Amanda wants, you can also use the SUM function , which calculates the sum of a
collection of numbers. The syntax of the SUM function is SUM( number1, [ number2 , …]),
which is similar to that of the AVERAGE function.
You’ll use the SUM function now to begin calculating the values Amanda needs, start-
ing with the values for the month of January.
Search JabSto ::

Custom Search