How to round up to the nearest five
 

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.

How to round up to the nearest five
 

Hi,

Try this

=CEILING(A1,5)
Mike

"James" wrote:

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.

How to round up to the nearest five
 

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
---------------
Jacob Skaria


"James" wrote:

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.

How to round up to the nearest five
 

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.


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"James" wrote:

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.