mround

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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

Round Down to the nearest multiple 2
Round time up to nearest :15 2
MROUND 4
Rounding numbers 5
Round formula 1
rounding up to nearest specified whole number 1
MROUND(F2,TIME(0,0,5)) 2
Rounding up or down decimals to the nearest 5 2

Back
Top