=ROUND(value,-1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tiya" wrote in message
...
hi
I want to round of near to zero. i.e.

If there is a qty * Rate = amt
456*89=40584 than i want to round of like 40580 i want to make last digit
0(zero)
Is any help

Thanks in Advance.

Tiya