Microsoft Office Tutorials and References
In Depth Information
AVERAGE, ROUND, and ROUNDUP Functions
The AVERAGE function computes the average of a set of values. Figure E-21 shows the use of the AVERAGE
function in cell C17:
AVERAGE function in cell C17
Notice that the value shown is a real number with many digits. What if you wanted to have the value
rounded to a certain number of digits? Of course, you could format the output cell, but doing that only
changes what is shown on the screen. You want the cell
s contents actually to be the rounded number.
Therefore, you need to use the ROUND function. Its syntax is:
ROUND(number, number of digits)
Figure E-22 shows the rounded average time (with two decimal places) in cell G17.
ROUND function used in cell G17