I didn't know, that round function accepts negative second parameter. Would it work for negative numbers (not that I need it, but now just from curiosity) :)?
>
lnNum = 4567
>? Round(lnNum, -(Len(Transform(lnNum))-1))
>
>>Hi everyone,
>>
>>I'd like to convert numbers to the following:
>
>>5->5 ROUND(...,0)
>>52->50 ROUND(...,-1)
>>333->300 ROUND(...,-2)
>>4567->5000 ROUND(...,-3)
>>1234567->1000000, e.g. to the round number.
>>
>>What would be the simplest algorithm for this?
>>
>>Thanks in advance.
If it's not broken, fix it until it is.
My Blog