Excel - =MROUND Solved

Question

Hello,
I have an Office program in English. Do you know what the formula is to round to the nearest 0.05 in English (the equivalent of =ROUND.UP.TO.MULTIPLE)?
Thank you for your attention and have a nice day :-)
Chazey

Configuration: Windows XP Internet Explorer 7.0

michel_m · Accepted Answer

Hello, MROUND while we're at it round down ----> ROUNDUP round up ------> ROUNDDOWN  you have a file delivered with Excel "vbalist.xls" that provides the translations... -- :-x

chazey · Answer

Thank you very much michel_m, it's perfect, just what I was looking for :-)  However, I can't find the file vbalist.xls ... file, open, ...??  If you have another two minutes for me...

michel_m · Answer

c:\program files\microsoft office\office XX\1036

XX depends on your version. But I just checked, "round to multiple" is not there (add-in - analysis tool ???)
Otherwise, on the excellent site Excelabo, download the AV evaluate file with tons of valuable examples...
http://excelabo.net/
--
:-x

chazey · Answer

Thank you again!! It's great! It's very nice to spend time helping others... I really appreciate it (I'm sure others do too). Have a good day!

Excel - =MROUND

4 réponses

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french