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
|