Solved

Excel Rounding Numbers

Posted on 2013-12-05
2
435 Views
Last Modified: 2013-12-05
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
Comment
Question by:submarinerssbn731
2 Comments
 
LVL 6

Accepted Solution

by:
Spyder2010 earned 500 total points
ID: 39699433
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
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39699446
Or

=CEILING(K1,1)
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
create excel pivot chart 12 43
Multiple Open Excel Spreadsheets 12 41
excel count months in date range 6 13
Need excel formula correction. 5 14
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question