View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default rounding up after SUM

=CEILING(D5/D3,1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"fbcmusicmark" wrote in message
...
I have a table that I am working with where I want to do a =SUM (D5/D3)
function and then round up the answer to the next integer. Any help will

be
appreciated.