| 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 |
| 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) | |||
Threaded Mode
