Let's say I have a value of 172 in cell A1. How do I write a formula that will round this number to the nearest hundredth in A2?
Let's say I have a value of 172 in cell A1. How do I write a formula that will round this number to the nearest hundredth in A2?
Try:
=Ceiling(A1,100)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Your title says round up, your post says nearest hundredth, and your example suggests nearest hundred. Pick one you like:
NBVC's example: round up to nearest 100
=ROUNDUP(A1, 2) round up to nearest 1/100
=ROUND(A1, 2) round to nearest 1/100
=ROUND(A1, -2) round to nearest 100
Last edited by shg; 07-09-2008 at 06:24 PM.
Exactly right. Thanks.
We are left to wonder ...
LOL, I was looking to round to the nearest hundred:
Thanks!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks