|Your parentheses are in the wrong places.|
As just one example...
The Red ) does not belong there since it essentially ends the first IF statement. That means that you have no value_if_false for the first IF.
You've repeated that same error throughout the formula, meaning that none of your IF's have a value_if_false argument.
Place your cursor in the formula bar and use the right arrow to move through the formula. You'll see that basically what you have is a bunch of independent IF statements, one right after the other.
Frankly, I'm surprised that Excel even accepted the formula, but I'm not going to try and figure out why.
A Nested IF should look something like this:
=IF(AND(M3=$B$243,N3=$C$243),L3*$D$243, IF(AND(M3=$B$244,N3=$C$244),L3*$D$244 ,IF(AND(...)))
Eventually, at the end of the entire formula, you'll have multiple close parentheses to close all of the IF's.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.