mround fuction not working

**gcooper** · 01-14-2011, 07:26 AM

Hi All,

I am having a problem using the mround function. I would like to round a given number to the nearest multiple of 5 using the formula below:

Please Login or Register  to view this content.

When i do this, I get the following error message:

#NAME?

I have tried this formula on a collegues computer using the same workbook and it works correctly.

Is there a reason why this isn't working on my computer?

Thanks,

Graeme

PS. using excel 2003 sp2

**DonkeyOte** · 01-14-2011, 07:33 AM

MROUND is part of the Analysis ToolPak pre XL2007 - you must activate this Add-In via Tools -> Add-Ins

Non ATP version would be:

Please Login or Register  to view this content.

**gcooper** · 01-14-2011, 07:37 AM

Thanks for your help, worked a treat.

Graeme

**DPKologie** · 05-29-2012, 02:27 AM

Hi,

I've got a vexing situation when using the mround function. I am utilizing the following formula:

=mround(average(g$2:g$4),0.05)

and receiving "#num" error messages. After trouble-shooting extensively, it appears that the formula works when the result is a positive number; it brings up the "#num" error message when the result is a negative number.

This seems to me to be retarded. How is it that Excel cannot deal with negative numbers? Is my version buggy, or does someone know a fix within the syntax of the formula? All help will be mucho appreciado.

**arlu1201** · 05-29-2012, 02:55 AM

DPKologie,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.