Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula needed to round up a value to a whole number
I'm making a cost estimation sheet, and need a cell to publish a whole
number. This cell is the result of a division formula involving two other cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon = 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons. Please help! Thanks, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula needed to round up a value to a whole number
=roundup(a1,0)
or =roundup(a1/a2,0) John A. wrote: I'm making a cost estimation sheet, and need a cell to publish a whole number. This cell is the result of a division formula involving two other cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon = 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons. Please help! Thanks, John -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula needed to round up a value to a whole number
John:
I don't think this is a programming question, but you can use the Round Function as in this example: =ROUND(B3/A3,0) When creating the formula, just start with the =ROUND( Then use your mouse to click the cells, and when finished, use zero as the number of places to round. Regards, -- Rich Locus Logicwurks, LLC "John A." wrote: I'm making a cost estimation sheet, and need a cell to publish a whole number. This cell is the result of a division formula involving two other cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon = 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons. Please help! Thanks, John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula needed to round up a value to a whole number
This was exactly what I needed Rich. Worked great.
Thanks!!! "Rich Locus" wrote: John: I don't think this is a programming question, but you can use the Round Function as in this example: =ROUND(B3/A3,0) When creating the formula, just start with the =ROUND( Then use your mouse to click the cells, and when finished, use zero as the number of places to round. Regards, -- Rich Locus Logicwurks, LLC "John A." wrote: I'm making a cost estimation sheet, and need a cell to publish a whole number. This cell is the result of a division formula involving two other cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon = 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons. Please help! Thanks, John |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula needed to round up a value to a whole number
yours worked too Dave.
Thanks!!! "Dave Peterson" wrote: =roundup(a1,0) or =roundup(a1/a2,0) John A. wrote: I'm making a cost estimation sheet, and need a cell to publish a whole number. This cell is the result of a division formula involving two other cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon = 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons. Please help! Thanks, John -- Dave Peterson . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula needed to round up a value to a whole number
Be aware that there is a difference on how those two functions work.
Try it with: =round(1.1,0) and =roundup(1.1,0) I'm not sure which you want. John A. wrote: yours worked too Dave. Thanks!!! "Dave Peterson" wrote: =roundup(a1,0) or =roundup(a1/a2,0) John A. wrote: I'm making a cost estimation sheet, and need a cell to publish a whole number. This cell is the result of a division formula involving two other cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon = 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons. Please help! Thanks, John -- Dave Peterson . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to round number up to always end in X.X9 | Excel Worksheet Functions | |||
can you round a number then use it in another formula | Excel Discussion (Misc queries) | |||
How do I round a formula generated number | Excel Worksheet Functions | |||
formula to round up any number less than 35 upto 35. | Excel Discussion (Misc queries) | |||
i would like to know a formula on how to round a number to 500 | Excel Discussion (Misc queries) |