>>>How to find the 10 multiple immediately higher then a number.
>>>
>>>e.g.
>>>
>>>2 ---------- 10
>>>15----------20
>>>17----------20
>>>21----------30
>>>41----------50
>>>
>>>Seems simple but I cannot imagine a function to do it.
>>
>>Just for variety (and assuming no negative values):
x -MOD(x,10)+10
Works with values other than 10 as well :-}
>
>Another option, that does work with negative numbers, is:
>
>ceiling(x/10)*10
>
Hi,
Think Al already suggested that one ;-}