I wish to round a series of number to the nearest hundred. i.e. 5689 to 5700
OR 4344 to 4300 OR 2100 to 2100. How can i do this in a formula?

Thanks

Assuming the first number is in cell A1, in cell B2 the formula is
=ROUND(A1,-2)

"faberk" wrote:

I wish to round a series of number to the nearest hundred. i.e. 5689 to 5700
OR 4344 to 4300 OR 2100 to 2100. How can i do this in a formula?

Thanks

Thank you very much!

"SVC" wrote:

Assuming the first number is in cell A1, in cell B2 the formula is
=ROUND(A1,-2)

"faberk" wrote:

I wish to round a series of number to the nearest hundred. i.e. 5689 to 5700
OR 4344 to 4300 OR 2100 to 2100. How can i do this in a formula?

Thanks