Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Div/01
=(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: http://www.excelforum.com/member.php...o&userid=26781 View this thread: http://www.excelforum.com/showthread...hreadid=493739 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Div/01
=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) "jeda67" wrote in message ... =(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: http://www.excelforum.com/member.php...o&userid=26781 View this thread: http://www.excelforum.com/showthread...hreadid=493739 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF - #DIV/01 | Excel Discussion (Misc queries) |