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

Charlotte

Try =MROUND(N29/6,5)

Any help?

Regards

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

Robb,

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

Char

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:

=ROUND((N29/6)/0.5,0)*0.5

Aladin

===========

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.