Not VB but hopefully some help

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

In Excel make a new module, and add a new public function to that. It will then be usable as a function, and will appear under "User-Defined Functions" in the list.