| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roundup Function
Is there a way to use the ROUNDUP function within another formula? I have an
IF formula and want to round up the results to the nearest whole number. I've created a workaround using cells to the side of my work area that accomplish this, but I would like to know if it can all be combined into one formula. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roundup Function
Yes you can embed the roundup function in an If formula. We would need more
details to help you proceed. Perhaps post an attempt at your formula with a description of what you want... -- HTH... Jim Thomlinson "bgcooker" wrote: Is there a way to use the ROUNDUP function within another formula? I have an IF formula and want to round up the results to the nearest whole number. I've created a workaround using cells to the side of my work area that accomplish this, but I would like to know if it can all be combined into one formula. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roundup Function
Here is the formula I'm using,which gives me the correct result. I would
like round up the result of this formula. Thanks very much for your help. =IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)) "Jim Thomlinson" wrote: Yes you can embed the roundup function in an If formula. We would need more details to help you proceed. Perhaps post an attempt at your formula with a description of what you want... -- HTH... Jim Thomlinson "bgcooker" wrote: Is there a way to use the ROUNDUP function within another formula? I have an IF formula and want to round up the results to the nearest whole number. I've created a workaround using cells to the side of my work area that accomplish this, but I would like to know if it can all be combined into one formula. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roundup Function
Since zero rounded up is zero you can just place the roundup around the
entire formula... =ROUNDUP(IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)), 0) -- HTH... Jim Thomlinson "bgcooker" wrote: Here is the formula I'm using,which gives me the correct result. I would like round up the result of this formula. Thanks very much for your help. =IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)) "Jim Thomlinson" wrote: Yes you can embed the roundup function in an If formula. We would need more details to help you proceed. Perhaps post an attempt at your formula with a description of what you want... -- HTH... Jim Thomlinson "bgcooker" wrote: Is there a way to use the ROUNDUP function within another formula? I have an IF formula and want to round up the results to the nearest whole number. I've created a workaround using cells to the side of my work area that accomplish this, but I would like to know if it can all be combined into one formula. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roundup Function
Great - thanks again for your help. I appreciate it.
"Jim Thomlinson" wrote: Since zero rounded up is zero you can just place the roundup around the entire formula... =ROUNDUP(IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)), 0) -- HTH... Jim Thomlinson "bgcooker" wrote: Here is the formula I'm using,which gives me the correct result. I would like round up the result of this formula. Thanks very much for your help. =IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)) "Jim Thomlinson" wrote: Yes you can embed the roundup function in an If formula. We would need more details to help you proceed. Perhaps post an attempt at your formula with a description of what you want... -- HTH... Jim Thomlinson "bgcooker" wrote: Is there a way to use the ROUNDUP function within another formula? I have an IF formula and want to round up the results to the nearest whole number. I've created a workaround using cells to the side of my work area that accomplish this, but I would like to know if it can all be combined into one formula. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roundup Function
On Feb 24, 9:54 am, bgcooker
wrote: Here is the formula I'm using,which gives me the correct result. I would like round up the result of this formula. Thanks very much for your help.. =IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)) =max(0,round((C14-D24)/1800,0)) ----- original posting ----- On Feb 24, 9:54*am, bgcooker wrote: Here is the formula I'm using,which gives me the correct result. *I would like round up the result of this formula. *Thanks very much for your help. =IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)) "Jim Thomlinson" wrote: Yes you can embed the roundup function in an If formula. We would need more details to help you proceed. Perhaps post an attempt at your formula with a description of what you want... -- HTH... Jim Thomlinson "bgcooker" wrote: Is there a way to use the ROUNDUP function within another formula? *I have an IF formula and want to round up the results to the nearest whole number. * I've created a workaround using cells to the side of my work area that accomplish this, but I would like to know if it can all be combined into one formula.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| roundup function | Excel Discussion (Misc queries) | |||
| ROUNDUP Function | Excel Discussion (Misc queries) | |||
| Roundup Function | Excel Worksheet Functions | |||
| can I add a column and roundup with 1 function? | Excel Discussion (Misc queries) | |||
| Roundup Function | Excel Discussion (Misc queries) | |||
Hybrid Mode
