Thread: Round up
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Round up

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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Becky Robinson Paine" wrote in message
...
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