Rounding averages

[gentleman9]

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?

 

[Domenic]

Try...

=ROUND(AVERAGE(A11:C11)/0.5,0)*0.5

Hope this helps!

 

[Doug.T]

Try this:
=CEILING(A11:C11,0.5)

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

 

[timorrill]

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

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

Hope this helps!

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

 

[gentleman9]

The MROUND function worked like a charm thanks for the help!