I tryed the ISERROR function also... However I'm haveing the same
problem.
=IF(ISERROR((B4*F4,H4*L4,N4*R4,T4*X4,Z4*AD4,AF4*AJ 4,AL4*AP4,AR4*AV4,AX4*BB4,BD4*BH4,BJ4*BN4,BP4*BT4, BV4*BZ4,CB4*CF4,CH4*CL4,CN4*CR4,CT4*CX4,CZ4*DD4,DF 4*DJ4,DL4*DP4,DR4*DV4,DX4*EB4,ED4*EH4)/EN4),0,((B4*F4,H4*L4,N4*R4,T4*X4,Z4*AD4,AF4*AJ4,AL 4*AP4,AR4*AV4,AX4*BB4,BD4*BH4,BJ4*BN4,BP4*BT4,BV4* BZ4,CB4*CF4,CH4*CL4,CN4*CR4,CT4*CX4,CZ4*DD4,DF4*DJ 4,DL4*DP4,DR4*DV4,DX4*EB4,ED4*EH4)/EN4))
--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile:
http://www.excelforum.com/member.php...o&userid=32007
View this thread:
http://www.excelforum.com/showthread...hreadid=529992