Julie:
I have tried splitting up the equation into parts, but the results are
not consistent. See my later post to get the details of the original.

John

"JulieD" wrote:

Hi John

check out http://www.cpearson.com/excel/nested.htm
it may provide a solution for you

Cheers
JulieD


"John Simons" <John wrote in message
...
I am trying to convert an old Lotus 1-2-3 spreadsheet into Excel. I have
several cells that contain multiple nested IF statements. I understand
from
the documentation that there is a limitation in Excel that says that you
can
only have 7 levels of nested IF statements. I have a need to go as many
as
18 levels of nested IF statements. Is there any way to cajole Excel into
not
choking on this nesting? There are so many things that Excel does better
than Lotus 1-2-3, but this is one big negative for Excel. Thanks for any
input you can provide.