=IF(L43*M43=0,0,M43*(1-O43)) =IF(L45*M45=0,0,IF(LOOKUP(R45,$AE$22:$AE$29,$AF$22:$AF$29)<>0,LOOKUP(R45,$AE$22:$AE$29,$AF$22:$AF$29),IF(L45*M45=0,0,IF(LOOKUP(S45,$M$18:$M$37,$AD$18:$AD$37)<>0,LOOKUP(S45,$M$18:$M$37,$AD$18:$AD$37),AD45+AG45)))) I need some suggestions how to write all these formulas with dynamic expressions? Please help anyone as soon as possible ? it is very urgent Any suggestions will be appreciated. Thanks in advance