mround

G

Guest

hi i am in the process of creating an excel markbook, and would like my
averages rounded up to the nearest multiple of 5. i used this formula
=mround(a2,5) and got back #name error message. help needed

alcidd
 
B

Bernard Liengme

MROUND is part of Analysis ToolPak. It must be installed from the Office
disk and then attached using Tools|Addins
=ROUND(A1/5,0)*5 will also achieve what you want

Best wishes
 
M

Myrna Larson

If you look at Help for this function, you will find an exact description of
this error message, what it means, and what to do about it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MROUND(F2,TIME(0,0,5)) 2
MROUND 4
Rounding up or down decimals to the nearest 5 2
Round to nearest multiple 3
Round formula 1
Why doesn't MROUND work? 2
Excel 2007 from Excel 2003 #N/A Problem 1
Rounding to the nearest quarter hour no longer working 4

Top