The limit is hard-coded and cannot be changed (still there in 2003).
Often people can restructure what they are trying to do to use a lookup
table.

Jerry

SOT wrote:

I am using Excel 2000. Is there a way around the 7 limit on a nested IF?

Thanks