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

Here's what I came up with: (been a while for me and .123)

1]
=IF(S11="","",IF(Y111,"OK",IF(Z111,"OK",IF(AA11 1,"OK",IF(AB111,"OK",IF(AC111,"OK","Not
OK"))))))

2] =IF(B154=" "," ",DSUM($AUTO~op!$K$8:$AUTO~op!$O$851,"Q",B154:B155 ))
(note: read the instructions in Excel help for the format of the
DSUM function--in a blank cell, click InsertFunction and choose DSUM
from the show all listing for details)

3] =IF(K14="
","Z",VLOOKUP(K14,'C:\Planning\[mmdotr.123]SheetE!$C$4:$K$2609,5))

Untested, of course. I am not sure if 3] will work as it references a
.123 workbook

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=390500

Here's what I came up with: (been a while for me and .123)

1]
=IF(S11="","",IF(Y111,"OK",IF(Z111,"OK",IF(AA11 1,"OK",IF(AB111,"OK",IF(AC111,"OK","Not
OK"))))))

2] =IF(B154=" "," ",DSUM($AUTO~op!$K$8:$AUTO~op!$O$851,"Q",B154:B155 ))
(note: read the instructions in Excel help for the format of the
DSUM function--in a blank cell, click InsertFunction and choose DSUM
from the show all listing for details)

3] =IF(K14="
","Z",VLOOKUP(K14,'C:\Planning\[mmdotr.123]SheetE'!$C$4:$K$2609,5))

Untested, of course. I am not sure if 3] will work as it references a
.123 workbook

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=390500