rounding up after SUM

F

fbcmusicmark

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.
 
V

Vito

If all you are doing is dividing two values, then you do not need the
sum function.

Try: =Roundup(D5/D3,0)
 
B

Bob Phillips

=CEILING(D5/D3,1)

--

HTH

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