Z
zaharah
actually..I have a problem converting the formula from lotus.123 to
microsoft excel...can u help me convert this formula from lotus? here i
will an example of the formula..
1.
@IF(S11="","",@IF(Y11>1,"OK",@IF(Z11>1,"OK",@IF(AA11>1,"OK",@IF
(AB11>1,"OK",@IF(AC11>1,"OK","Not OK"))))))
2. @IF(B154=" "," ",@DSUM
($AUTO~op:$K$8..$AUTO~op:$O$851,"Q",M=B154))
3. @IF(K14=" ","Z",@VLOOKUP
(K14,<<C:\Planning\mmdotr.123>>$E:$C$4..$E:$K$2609,5))
this formula is from lotus.123...and I want to convert this formula to
microsoft excel...hope u can solve my problem..
tq very much..hope u can rply as soon as possible..tq
microsoft excel...can u help me convert this formula from lotus? here i
will an example of the formula..
1.
@IF(S11="","",@IF(Y11>1,"OK",@IF(Z11>1,"OK",@IF(AA11>1,"OK",@IF
(AB11>1,"OK",@IF(AC11>1,"OK","Not OK"))))))
2. @IF(B154=" "," ",@DSUM
($AUTO~op:$K$8..$AUTO~op:$O$851,"Q",M=B154))
3. @IF(K14=" ","Z",@VLOOKUP
(K14,<<C:\Planning\mmdotr.123>>$E:$C$4..$E:$K$2609,5))
this formula is from lotus.123...and I want to convert this formula to
microsoft excel...hope u can solve my problem..
tq very much..hope u can rply as soon as possible..tq