# Rounding averages

#### gentleman9

##### New Member
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?

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Domenic

##### MrExcel MVP
Try...

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

Hope this helps!

#### Doug.T

##### Board Regular
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
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.

#### gentleman9

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

Replies
19
Views
147
Replies
3
Views
109
Replies
6
Views
272
Replies
4
Views
66
Replies
2
Views
173

1,148,249
Messages
5,745,627
Members
423,964
Latest member
Dustin M

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back