View Single Post
  #1   Report Post  
Sam
 
Posts: n/a
Default Newbie: How to round down to the lowest 5

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