Round up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Becky,

try,

=roundup(a4,0)

hope this helps
Regards from Brazil
Marcelo


"Becky Paine" escreveu:
 
If your price data was in column A you could put a formula like this in the
next column. (Of course you would have to adjust the A10 cell to whatever the
last cell of your data wasa.)

=ROUNDUP(A1:A10,0)
 
Do I add it before the rest of my formula? My formula looks like this
((((cb*.465)*1.0775)+10.05)*1.55). Thanks!
 
Just highlight whatever cell you need to rounded up (or the entire shee
if you want)

go to Format Cells, Pick Currency, and just put 0 as your Decima
Place
 
=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?
 
yes try to use:

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

regards

"Becky Robinson Paine" escreveu:
 
=ROUNDUP((((cb*.465)*1.0775)+10.05)*1.55),0)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
That will round down numbers less than .5 if i am not mistaken, unless I
misread her 1st query she wants to round up all numbers.
 
Back
Top