converting formula from lotus.123 to excel

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
 
S

swatsp0p

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

1
=IF(S11="","",IF(Y11>1,"OK",IF(Z11>1,"OK",IF(AA11>1,"OK",IF(AB11>1,"OK",IF(AC11>1,"OK","No
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 th
DSUM function--in a blank cell, click Insert>Function and choose DSU
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
.123 workbook

Good Luck

Bruc
 
S

swatsp0p

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

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",B154:B155))
(note: read the instructions in Excel help for the format of the
DSUM function--in a blank cell, click Insert>Function 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top