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..." |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number rounding within a formula
first, using SUM does nothing additional and is unecessary
=D108/2 so =round(D108/2,0) -- Regards, Tom Ogilvy "T.R. Young" wrote in message ... 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..." |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number rounding within a formula
Thank you much, Tom! I appreciate that. Obviously, I'm a newbie... :)
-- "...I''m just a simple man, trying to make my way in the universe..." "Tom Ogilvy" wrote: first, using SUM does nothing additional and is unecessary =D108/2 so =round(D108/2,0) -- Regards, Tom Ogilvy "T.R. Young" wrote in message ... 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..." |
Reply |
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) |