Thread: Sum and Round all in one cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default Sum and Round all in one cell
=CEILING(A1,500)
--
David Biddulph

"BAHoffman" wrote in message
...
I need to know how to round the sum of a cell up to the nearest 500. Can
anyone help me with this?? I would appreciate it. Thanks.


Reply With QuoteReply With Quote