View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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