Thread: Sum and Round all in one cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default Sum and Round all in one cell
Try something like this:

=ROUNDUP(SUM(A1:A100)/500,0)*500

HTH,
Elkar


"BAHoffman" wrote:

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