Round up to the nearest whole number...
Sorry folks, I suspect I could find this with a decent google search, but i'm at work and finding a lot of random sites blocked, is anyone able to help?
I want a code that will run Q2:Q97 and for each number it will round up to the nearest whole number. i.e. 1.5, 1.4, 1.1 or 1.00001 would all become 2.
Many thanks in advance guys.
Last edited by Darth269; 12-17-2012 at 02:13 AM. Reason: SOLVED
Try this:
=ceiling(Q2,1)
Then fill down
- Moo
* Oops, you were looking for VBA solution. sorry!
Last edited by Moo the Dog; 12-17-2012 at 12:22 AM.
hi Darth269, another alternative using VBA would be:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Many thanks to both of you! Benishiryo - That was exactly what I needed thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks