Round near to Zero
=ROUND(qty * Rate,-1)
--
tj
"Tiya" wrote:
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
|