How to round up to the nearest five

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

 

[Mike H]

Hi,

Try this

=CEILING(A1,5)
Mike

 

[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

 

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