I have two conditions under True statement in IF. It only works if both conditions are met. Is it possible to dismiss one of the conditions (the one not being procced) and show only good one if other doesn't return a value.
IF($C$12="BB";
(INDEX(PARMSETS!$AF$3:$AF$1796;MATCH(1;INDEX(($M11=PARMSETS!$AD$3:$AD$3333)*
(N$9=PARMSETS!$AE$3:$AE$3333););0))+
(INDEX(PARMSETS!$AF$3:$AF$1796;MATCH(1;INDEX(($M11=PARMSETS!$AD$3:$AD$3333)*
("M_F_S"=PARMSETS!$AB$3:$AB$3333););0))))