View Single Post
  #1   Report Post  
zaharah
 
Posts: n/a
Default converting formula from lotus.123 to excel


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