How to roundup a number to the closest ten?

Question

Probably the title is not very suggestive.

Let me explain you with an example. I have:

12345.6 
2345.1
12345.00000001

I want those numbers to be roundup to 12350.
How can I do this?

If possible, I would rather use formulas instead of VBA.

Answer 1

You could also use CEILING which rounds up to an integer or desired multiple of significance

ie
=CEILING(A1,10)
rounds up to a multiple of 10

12340.0001 will become 12350