Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
roundup function
I want to be able to have an amount in one cell then in aonther cell have the
following function =roundup(c10+15/.9,0) so it takes the amount in the first cell adds on 15 then divides by .9 (which increases by 10%) and then round the number. But excel doesn't like this. So i tried to put the brackets and the rounding just so =roundup(c10+15,0)/.9 which does bring the correct amount but doesnot round the final amount up. Does anyone know how or if this can be done? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
roundup function
Excel does division first before it does the addition. You can add a set or
parathensis to control to math operations. =ROUNDUP((C10+15)/0.9,0) If this doesn't solve your problem, perhaps you could post examples of numbers you would put in, and expected results. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Marge" wrote: I want to be able to have an amount in one cell then in aonther cell have the following function =roundup(c10+15/.9,0) so it takes the amount in the first cell adds on 15 then divides by .9 (which increases by 10%) and then round the number. But excel doesn't like this. So i tried to put the brackets and the rounding just so =roundup(c10+15,0)/.9 which does bring the correct amount but doesnot round the final amount up. Does anyone know how or if this can be done? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
roundup function
Well, loks like the issue is, with the first one, you are asking for c10 +
(15/.9).What you want to do is =ROUNDUP((C10+15)/.9,0) "Marge" wrote: I want to be able to have an amount in one cell then in aonther cell have the following function =roundup(c10+15/.9,0) so it takes the amount in the first cell adds on 15 then divides by .9 (which increases by 10%) and then round the number. But excel doesn't like this. So i tried to put the brackets and the rounding just so =roundup(c10+15,0)/.9 which does bring the correct amount but doesnot round the final amount up. Does anyone know how or if this can be done? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
roundup function
Yoiur problem isn't with ROUNDUP, but with the precedence of arithmetic
operations. See Excel help. -- David Biddulph Marge wrote: I want to be able to have an amount in one cell then in aonther cell have the following function =roundup(c10+15/.9,0) so it takes the amount in the first cell adds on 15 then divides by .9 (which increases by 10%) and then round the number. But excel doesn't like this. So i tried to put the brackets and the rounding just so =roundup(c10+15,0)/.9 which does bring the correct amount but doesnot round the final amount up. Does anyone know how or if this can be done? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Roundup or Ceiling Function to round to a specific number | 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) |