I am trying to convert Lotus 123 to Excel 97. In lotus there is a cell with 30 some if statements. When i copy that over to Excel it gives me an error. I believe that the limit is 7 ifs in one cell, but i need to figure away around this with. A macro will not work unless it is automatic.

Steve