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.

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.

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

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

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