Nested IF returning FALSE value help

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

Please Login or Register  to view this content.

The 3rd nested IF doesn't have a "what-if-false" argument... so that means that you don't have an argument to process when N2<=L2+K2+J2 is not TRUE.

That means indirectly, I was right, and the reason was because of a missed/misplaced parenthesis.