It's partially working.

If the EN5 has a number the formula is coming back with a #VALUE error.


Am I doing it wrong?

=IF(EN3=0,0
(B3*F3,H3*L3,N3*R3,T3*X3,Z3*AD3,AF3*AJ3,AL3*AP3,AR 3*AV3,AX3*BB3,BD3*BH3,BJ3*BN3,BP3*BT3,BV3*BZ3,CB3* CF3,CH3*CL3,CN3*CR3,CT3*CX3,CZ3*DD3,DF3*DJ3,DL3*DP 3,DR3*DV3,DX3*EB3,ED3*EH3)/EN3)


--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=529992