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

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

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

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