View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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