=5*ROUNDDOWN(A1/5,0)
Jerry
Sam wrote:
I am trying to write a formula that will allow me to round down the
lowest digit, say 5. For example if the value in A1= 1297.19 then the value
in A2 should display 1295.00 also if the value in A1=632.67 then I would
want to round down to 630.00.
Can anyone help?
Thanks
|