Excel_Illerate
New Member
- Joined
- Jun 28, 2011
- Messages
- 14
Hello all,
I was given a complete working Lotus 123 file. The below formula didn't convert to Excel when I re-saved the file. I haven't found a way to convert it to Excel use. Is there a way to re-write it so that I can use it in Excel? The file has numerous cells with this formula in it.
@IF(@IF(@ISERR(@DMAX($POWER_TABLE,"DRAW",DRAW<@IF(C11=0,$D$3,C11)#AND#(FIRST=C$9#OR#SECOND=C$9#OR#THIRD=C$9#OR#FOURTH=C$9#OR#FIFTH=C$9))),0,@DMAX($POWER_TABLE,"DRAW",DRAW<@IF(C11=0,$D$3,C11)#AND#(FIRST=C$9#OR#SECOND=C$9#OR#THIRD=C$9#OR#FOURTH=C$9#OR#FIFTH=C$9))),@DMAX($POWER_TABLE,"DRAW",DRAW<@IF(C11=0,$D$3,C11)#AND#(FIRST=C$9#OR#SECOND=C$9#OR#THIRD=C$9#OR#FOURTH=C$9#OR#FIFTH=C$9))," ")
Thanks ahead of time for any help with this conversion.
Excel_Illerate
I was given a complete working Lotus 123 file. The below formula didn't convert to Excel when I re-saved the file. I haven't found a way to convert it to Excel use. Is there a way to re-write it so that I can use it in Excel? The file has numerous cells with this formula in it.
@IF(@IF(@ISERR(@DMAX($POWER_TABLE,"DRAW",DRAW<@IF(C11=0,$D$3,C11)#AND#(FIRST=C$9#OR#SECOND=C$9#OR#THIRD=C$9#OR#FOURTH=C$9#OR#FIFTH=C$9))),0,@DMAX($POWER_TABLE,"DRAW",DRAW<@IF(C11=0,$D$3,C11)#AND#(FIRST=C$9#OR#SECOND=C$9#OR#THIRD=C$9#OR#FOURTH=C$9#OR#FIFTH=C$9))),@DMAX($POWER_TABLE,"DRAW",DRAW<@IF(C11=0,$D$3,C11)#AND#(FIRST=C$9#OR#SECOND=C$9#OR#THIRD=C$9#OR#FOURTH=C$9#OR#FIFTH=C$9))," ")
Thanks ahead of time for any help with this conversion.
Excel_Illerate