Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number rounding within a formula
Is it possible to round a number within a cell that contains a simple
formula? Here is what I want to do... D108 contains a whole number. Sometimes it's odd, sometimes it's even. In cell D109, I have the following formula; =SUM(D108/2) (this is the cell that I want rounded up to the nearest whole) In cell D110, I want to subtract D109 from D108. I have tried simply editing the number format to display a number with no decimal places, but this does not allow D110 to be accurate. I know that I could simply place a calculation cell on the spreadsheet, then make D109 simply have the roundup function for the calculation cell, but I was wondering if it is possible to do the math AND the roundup in the same cell. Thanks! -- "...I'm just a simple man, trying to make my way in the universe..." |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
rounding a number with a formula already in cell | Excel Worksheet Functions | |||
rounding a number created by a formula to a retail price | Excel Worksheet Functions | |||
Formula for rounding number to nearest hundred? | Excel Discussion (Misc queries) | |||
Formula for rounding number to nearest hundred? | Excel Discussion (Misc queries) |