Pls u mean i have to write like this
=IF(AND(INT(C2+2)=INT(L2+2),NOT(ISNA(MATC2+2H(INT( C2+2),C9:C10,0))))
,0,ABS(IF(INT(C2+2)=INT(L2+2),ROUND(24*(L2+2-C2+2),2),.....
WAITING !!!
SAM
--
Sambus
-----------------------------------------------------------------------
Sambusa's Profile:
http://www.excelforum.com/member.php...fo&userid=1496
View this thread:
http://www.excelforum.com/showthread.php?threadid=26588