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(Y111,"OK",@IF(Z111,"OK",@IF(AA 111,"OK",@IF
(AB111,"OK",@IF(AC111,"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
--
zaharah
------------------------------------------------------------------------
zaharah's Profile:
http://www.excelforum.com/member.php...o&userid=25642
View this thread:
http://www.excelforum.com/showthread...hreadid=390500