• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 496
  • Last Modified:

Excel Rounding Numbers

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
Steve Eckerman
Asked:
Steve Eckerman
1 Solution
 
Spyder2010Commented:
Use the RoundUp() function:

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

In your example spreadsheet, put in column K, row 2:
=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
 
Martin LissOlder than dirtCommented:
Or

=CEILING(K1,1)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now