# Rounding Up

#### atmospheric

##### Well-known Member
How can I round up the result of a formula to it's nearest 0.5?, and where am I going wrong with:

=MROUND(A1,0.5) where A1=1.46

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Try:

=CEILING(A1,0.5)

HTH,

Smitty

Thanks Smitty, but that returns an answer of 0.5 for every result.

Thanks Smitty, but that returns an answer of 0.5 for every result.

Can you give more examples of what the results should be?

I'd like the results to be:

1.46 to equal 1.5
7.09 to equal 7.5
15.65 to equal 16
78.78 to equal 79 etc

i.e. rounding the results UP to either the next .5 or whole number

HTH

Try,

=ROUNDUP(A1/0.5,0)*0.5

That works perfectly Brian, thanks.

Going back to my original question though, why can't I use MROUND? Or, to put it another way, What does MROUND do?

MROUND rounds to the nearest multiple (it rounds up and down).

But you want to round up to a multiple which is different.

For example:
7.09 with MROUND would round to 7 because it is closer to 7 than it is to 7.5

Thanks Hotpepper. I went back to the Excel Helpfile AGAIN...the reason it wouldn't work for me was that I didn't have the Analysis Toolpack loaded. The results as you describe are what I expected.

Thanks for everyones help.

Replies
4
Views
134
Replies
6
Views
336
Replies
4
Views
108
Replies
5
Views
422
Replies
18
Views
548

1,214,285
Messages
6,118,678
Members
448,845
Latest member
MrEbzz

### 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