MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rounding to the nearest .5

Posted by Charlotte Pulkowski on September 27, 2001 3:37 AM

I have a formula which reads =Round(+N29/6,1) which works correctly but I then need to be able to round it to the nearest .5 up or down. Does anyone have a solution for this. It would be most appreciated. Thanks

Posted by Robb on September 27, 2001 4:00 AM


Try =MROUND(N29/6,5)

Any help?


Posted by Charlotte Pulkowski on September 27, 2001 5:39 AM


I have excel 2000 and it is not recognizing the NAME - MROUND. Any other thoughts. Thanks


Posted by Aladin Akyurek on September 27, 2001 1:30 PM

For MROUND you need Analysis Toolpak. See if you can add that in by activating Tools|Add-ins.

Or try instead of MROUND:




Posted by charlotte pulkowski on September 28, 2001 12:54 AM

To both Aladin & Robb - my thanks for this help. I was desparately searching the web for any help and happened to come across this site. You have made my day and also my boss's day.