rounding up after SUM
 

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.

rounding up after SUM
 

You sure don't need the SUM()

=ROUNDUP(d5/D3,0)

"fbcmusicmark" wrote:

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.

rounding up after SUM
 

=ROUNDUP(SUM(D5/D3),0)

Vaya con Dios,
Chuck, CABGx3



"fbcmusicmark" wrote:

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.

rounding up after SUM
 

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

Try: =Roundup(D5/D3,0)


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=497665

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.