Round to nearest 100 in Excel

Round to nearest 100 in Excel

The following formula will round to the nearest 100 in Excel. It is based on the second argument. You can change the number and get the multiples of 10.

=Round(A1,-2)

In the above formula, -2 indicates nearest 100’s.

=round(A1/100,0)*100

 

About the author: admin

You must be logged in to post a comment.