| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
round up
How do I make a result round up to the nearest whole digit (1.2 = 2, not 1)
when that cell already has a formula in it? I found the formula for rounding, but can't figure out how to combine it with the formula that is already in the cell. James |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round up
If your formula is a straightforward calculation, then you would use:
=ROUNDUP(your_existing_formula,0) If the formula is part of an IF statement, then it would be something like this: =IF(A10,ROUNDUP(your_formula,0),"") Hope this helps - post your formula if you still can't figure it out. Pete James Horton Las Vegas wrote: How do I make a result round up to the nearest whole digit (1.2 = 2, not 1) when that cell already has a formula in it? I found the formula for rounding, but can't figure out how to combine it with the formula that is already in the cell. James |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round up
Pete: Thank you for trying to help. Your formula example was real close
too, but not close enough for me to figure it out on my own, I guess. The formula is: =IF(R410,SUM(R41:S41),"") "Pete_UK" wrote: If your formula is a straightforward calculation, then you would use: =ROUNDUP(your_existing_formula,0) If the formula is part of an IF statement, then it would be something like this: =IF(A10,ROUNDUP(your_formula,0),"") Hope this helps - post your formula if you still can't figure it out. Pete James Horton Las Vegas wrote: How do I make a result round up to the nearest whole digit (1.2 = 2, not 1) when that cell already has a formula in it? I found the formula for rounding, but can't figure out how to combine it with the formula that is already in the cell. James |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round up
Try this:
=IF(R410,ROUNDUP(SUM(R41:S41),0),"") Hope this helps. Pete James Horton Las Vegas wrote: Pete: Thank you for trying to help. Your formula example was real close too, but not close enough for me to figure it out on my own, I guess. The formula is: =IF(R410,SUM(R41:S41),"") "Pete_UK" wrote: If your formula is a straightforward calculation, then you would use: =ROUNDUP(your_existing_formula,0) If the formula is part of an IF statement, then it would be something like this: =IF(A10,ROUNDUP(your_formula,0),"") Hope this helps - post your formula if you still can't figure it out. Pete James Horton Las Vegas wrote: How do I make a result round up to the nearest whole digit (1.2 = 2, not 1) when that cell already has a formula in it? I found the formula for rounding, but can't figure out how to combine it with the formula that is already in the cell. James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round time maybe this explanation will help | Excel Discussion (Misc queries) | |||
| ROUND or "Precision as displayed"? | Excel Worksheet Functions | |||
| Round a number in nested function | Excel Worksheet Functions | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
