roundup function

M

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
 
S

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)
 
L

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.
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top