Rounding currency

[rick]

I want to round a long price list which currently has dollars and
cents into whole dollars such that the end result cell is whole dollars
without cents.
Rick

 

[Harald Staff]

Hi Rick

Price list. Assuming you want to round UP then.
=ROUNDUP(A1,0)

....or the more common
=ROUNDUP(A1,0)-0.01
which generates great bargains like 22.99 . Try even
=CEILING(A1,5)-0.01
to get 24.99 instead.

HTH. Best wishes Harald

 

[Paul Sheppard]

I want to round a long price list which currently has dollars and
cents into whole dollars such that the end result cell is whole
dollars
without cents.
Rick

Hi Rick

Try > =ROUND(SUM(A1:A4),0), change range A1:A4 to suit your data