>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 :-}