How to round up to the nearest five

  • Thread starter Thread starter James
  • Start date Start date
J

James

How can I make a 34 to a 35 etc etc.

How can i round up any number to the nearest five or ten?

E.G a 39 to a 40, a 6 to a 10 and a 1132 to a 1135.

thanks.
 
When you say nearest..39 should be 40 and 36 should be 35 right?

=ROUND(A1/5,0)*5

If this post helps click Yes
 
I agree that he confused the issue with his statement:
"round UP... nearest 5..."
which would imply that 6 should be rounded DOWN to 5, but the example data
showed "a 6 to a 10 and 1132 to 1135" so it does look like always round up.
 
Back
Top