Rounding averages

gentleman9

New Member
Joined
Sep 21, 2006
Messages
5
Ok I'm now trying to round an average of three cells up/down to the nearest 0.5 I've tried:

=ROUND(AVERAGE(A11:C11),1)

how did I screw this formula up?
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Doug.T

Board Regular
Joined
Sep 19, 2006
Messages
80
Try this:
=CEILING(A11:C11,0.5)

edit: it's not quite what you are looking for as it always rounds up
 

timorrill

Well-known Member
Joined
Sep 20, 2006
Messages
528
Hi gentleman9,

You will need to use the MROUND function, which is part of the Analysis ToolPak. The Analysis ToolPak can be found in the Tools -> Add-Ins... menu.

Then the formula is

Code:
=MROUND(AVEAGE(A11:C11),0.5)

Hope this helps!

PS -- You may have to install the Analysis ToolPak from Microsoft Office CDs.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,955
Messages
5,545,167
Members
410,667
Latest member
Gaexel
Top