Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# Excel Rounding Numbers

Posted on 2013-12-05
Medium Priority
487 Views
Hello experts,

In column K, I need a formula that will round the numbers in Column H (# of skids) up to the nearest whole number. Even if the number is 1.001 it should be rounded up, not down, and appear as "2".

Thanks

Drew
weights-ex.xls
0

LVL 6

Accepted Solution

Spyder2010 earned 2000 total points
ID: 39699433
Use the RoundUp() function:

http://office.microsoft.com/en-us/excel-help/round-a-number-HP003056144.aspx#_Toc272405093

=RoundUp(H2,0)

Then use the Fill Down function to populate the rest of your rows.  The ',0' tells it to round to the next whole number.  There are other options(listed in my above link) that will let you round up to specific decimal places.
0

LVL 49

Expert Comment

ID: 39699446
Or

=CEILING(K1,1)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
###### Suggested Courses
Course of the Month12 days, 4 hours left to enroll