Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions |