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 ??