Ceiling a number
I need to round or ceiling some numbers to the next number up, that ends with a cero.
11,234 to 11,240
41,398 to 41,400
3,456 to 3,460
11,299 to 11,300
Ceiling ( YourNumber / 10 ) * 10
Edit after reading raybaudi: I assumed it was a thousands separator. Otherwise use raybaudi's suggestion.
Let([n = Abs ( Mod ( number ; 1 ) ) ;r = Right ( n ; 1 ) ;d = Length ( n ) - 1];number + Choose ( r ; 0 ; 9 ; 8 ; 7 ; 6 ; 5 ; 4 ; 3 ; 2 ; 1 ) * 10 ^ - d)
Edit: re-reading your post I realized that your comma could be a thousand separator, but I thought that it was a decimal separator ( I'm from Italy ).
Thank's a lot the CEILING answer worked just perfect.
Retrieving data ...