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
|