>Hi,
>
>i can't round up a value with this function
>example: 1.61 became 1.7 or 1.661 became 1.67
>
>what function i use for this case ?
>
>thx,
>Abit
You're not rounding, you're doing an absolute round-up. Try this :
Ceiling(lnNum * 10^lnRound)*10^-lnRound
Cetin