software

=(TRUNC(C4)*60 (C4-TRUNC(C4))*100)/(TRUNC(G4)*60 (G4-TRUNC(G4))*100)
I have this formula in one of my spreadsheets, the only problem I have
is when I don't have amounts in e.g C4 and then G4 I get a #div01 not a
zero.

Is there anyway if I haven't got amounts in the cells this refers to
that I can get a zero so the sum that adds up the columns with this
formula in it adds up.--
jeda67
------------------------------------------------------------------------
jeda67's Profile: www.excelforum.com/member.php...oamp;userid=26781
View this thread: www.excelforum.com/showthread...hreadid=493739=IF(OR(C4=0,G4=0),0,(TRUNC(C4)*60 (C4-TRUNC(C4))*100)/(TRUNC(G4)*60 (G4-TRUN
C(G4))*100))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jeda67quot; gt; wrote in
message ...
gt;
gt; =(TRUNC(C4)*60 (C4-TRUNC(C4))*100)/(TRUNC(G4)*60 (G4-TRUNC(G4))*100)
gt; I have this formula in one of my spreadsheets, the only problem I have
gt; is when I don't have amounts in e.g C4 and then G4 I get a #div01 not a
gt; zero.
gt;
gt; Is there anyway if I haven't got amounts in the cells this refers to
gt; that I can get a zero so the sum that adds up the columns with this
gt; formula in it adds up.
gt;
gt;
gt; --
gt; jeda67
gt; ------------------------------------------------------------------------
gt; jeda67's Profile:
www.excelforum.com/member.php...oamp;userid=26781
gt; View this thread: www.excelforum.com/showthread...hreadid=493739
gt;