1st Formula
Code: Select all
IF(AND(G$14="F",G$28<0),$M$52-G$18,IF(G$14="F",$M$52,IF(G$14=$Q$51,$Q52,IF(G$14=$P$51,$P52,IF(G$14=$O$51,$O52,IF(G$14=$N$51,$N52,IF(OR(G$14=$M$51,G$14="B1P"),$M52,"-")))))))
Code: Select all
IF(AND(G$14="F",G$28<0),$M$53-G$19,IF(AND(G$14="F",G$28>0),$M$53+G$16,IF(G$14=$Q$51,$Q53,IF(G$14=$P$51,$P53,IF(G$14=$O$51,$O53,IF(G$14=$N$51,$N53,IF(OR(G$14=$M$51,G$14="B1P"),$M53,"-")))))))