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.
 
Back
Top