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.