Can Lotus 123 @DMAX be converted to Excel formula?

[Excel_Illerate]

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

 

[Excel_Illerate]

The correct answer is in the 123 workbook that I am attempting to recreate as an Excel workbook.

As I stated, your formula worked, but it did not provide the expected results.

I still need to figure out how to create the original 123 formula in Excel.

Thank you for your help.