Round() won't work for the first example - Ceiling is better - but works different for negative numbers
>You can use ROUND() function with negative second parameter
>
>lnValue = 8362
>? ROUND(lnValue,-1)
>lnValue = 8365
>? ROUND(lnValue,-1)
>
>
>>I have create a form I have placed four text boxes namely 1.txtfirst 2.txtsecond 3. txtthree 4..txttotal. I want txttotal value rounded up next to 10.
>>
>>Let assume the txttotal value is 8362 I want rounded to 8370.
>>
>>How to write code?
Gregory