How to round up to the nearest five

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.
 
J

Jacob Skaria

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
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top