How to Round Up Number (non-decimal), ex. Money

[AnggaRifandi]

Hi all,


I have question from my father about how to round up number in Excel.

So my father have this number IDR 30,189,349 and want the result become IDR 30,189,000 because 349 is lower than 500.

So if the number is IDR 30,189,500 the result should be IDR 30,190,000.


Really appreciate any kind of help

 

[AnggaRifandi]

@Chandoo

It works. Really appreciate it Chandoo.


Problem solved.