ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - hi (https://www.excelbanter.com/excel-discussion-misc-queries/29551-hi.html)

faberk

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

SVC

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

faberk

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

All times are GMT +1. The time now is 11:00 PM.