I have two set of formulas in H & I column and i want both of them give me same results.e.g column H has =IF(AND($C$2<>0,$E2<>0),IF(IF($B2="51",0,IF($A2="1 ",(($F2-$G2)*$D2%),$K2))<0,0,IF(AND($C2<>0,$E2<>0,IF($E2=0 ,0,IF($B2="51",0,IF($A2="1",(($F2-$G2)*$D2%),$K2)))),0))) with some more test but it gives false.
thanks




Reply With Quote
Bookmarks