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.