Thread: Rounding currency
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Paul Sheppard[_14_] Paul Sheppard[_14_] is offline
external usenet poster
  
Posts: 1
Default Rounding currency

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

Reply With QuoteReply With Quote