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

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

skrev i melding
oups.com...
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

Wrote:
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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=466070