still unable to get it..

what I want is the following:

0.171 round to 10 is 0.180

0.264 round to 10 is 0.270

0.397 round to 10 is 0.400

1.993 round to 10 is 2.000

using the same logic I want to round to 50 and 100

"Michael A. Covington" <lo**@ai.uga.edu.for.addresswrote in message

news:%2******************@TK2MSFTNGP04.phx.gbl...

"Jassim Rahma" <jr****@hotmail.comwrote in message

news:88**********************************@microsof t.com...
>>I have a number, for example 0.152 or 1.729 and I want to allow to round

to the first 0.010 or 0.050 or 0.100

One approach:

Use the Decimal data type.

Multiply by 100, or 20, or 10.

Round to nearest integer.

Divide by the number you multipied by.

But also look for built-in rounding functions.