Thread: Round up
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Tim M
 
Posts: n/a
Default Round up

=ROUNDUP(((((cb*0.465)*1.0775)+10.05)*1.55),0)

Not sure what cb is in your formula, i assume that is a cell perhaps?

"Becky Robinson Paine" wrote:

Do I add it before the rest of my formula? My formula looks like this
((((cb*.465)*1.0775)+10.05)*1.55). Thanks!
--
B Paine


"Marcelo" wrote:

Hi Becky,

try,

=roundup(a4,0)

hope this helps
Regards from Brazil
Marcelo


"Becky Paine" escreveu:

Hello,

I have pricing grids that I need to have rounded up to the next dollar. I
can't figure out how to apply this to all the cells. Can you help?

Thanks,

Becky Paine