roundup function

[Marge]

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

 

[Sean Timmons]

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)

 

[Luke M]

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.

 

[David Biddulph]

Yoiur problem isn't with ROUNDUP, but with the precedence of arithmetic
operations. See Excel help.