The limit on nested functions like IF is seven to a formula.

Workarounds using named ranges examples available at Chip Pearson's site.

http://www.cpearson.com/excel/nested.htm


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 10:21:01 -0800, mr_concrete
wrote:

I am getting an error message on the 8th time I use IF(AND) in the same
formula. Is there a maximum number of times you can use this combonation in a
singular formula?? If so, how do I end the first part of the formula but
start a second part ??