Nested IF returning FALSE value help

[crash884]

Hello, I have nested if formula that if I change qty of my cell N2 it returns a FALSE value. I have attached sample to illustrate it better. If I put the qty in cell N2 to 584 The formula calculates just fine, however anything after that is false. I cannot figure out why. I know that J2+K2+l2 equal 584, but even though there is no numbers in the other cells it should not return false but the same number as if the qty was 584. The formula that I am talking about is in cell O2.


Here is the formula in O2

=IF(N2<=L2,L3,IF(N2<=L2+K2,SUM(((L2*L3)+((N2-L2)*K3))/N2),IF(N2<=L2+K2+J2,SUM(((L2*L3)+(K2*K3)+((N2-J2)*J3)/N2),IF(N2<=L2+K2+J2+I2,SUM(((L2*L3)+(K2*K3)+(J2*J3)+((N2-I2)*I3)/N2)),IF(N2<=L2+K2+J2+I2+H2,SUM(((L2*L3)+(K2*K3)+(J2*J3)+(I2*I3)+((N2-H2)*H3)/N2)),IF(N2<=L2+K2+J2+I2+H2+G2,SUM(((L2*L3)+(K2*K3)+(J2*J3)+(I2*I3)+(H2*H3)+((N2-G2)*G3)/N2)),IF(N2<=L2+K2+J2+I2+H2+G2+F2,SUM(((L2*L3)+(K2*K3)+(J2*J3)+(I2*I3)+(H2*H3)+(G2*G3)+((N2-F2)*F3)/N2)),IFERROR(SUMPRODUCT(C3:L3,C2:L2)/SUM(C2:L2),"")))))))))