Rounding currency

[[email protected]]

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

[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

[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

<[email protected]> skrev i melding
news:[email protected]...
> 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
>