Versions of Excel older than XL 07 have a limit of 7 nested functions. For
some ideas on how to circumvent this limitation see he
http://www.ozgrid.com/Excel/nested-function-limit.htm

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"fiur" wrote:

hi here is my problem I need more than 7 "if" in a commando example:
=IF(AND(C3=1;C5=1);"1-7";IF(AND(C3=1;C5=2);"8-14";IF(AND(C3=1;C5=3);"15-21";IF(AND(C3=1;C5=4);"22-28";IF(AND(C3=2;C5=1);"29-35";IF(AND(C3=2;C5=2);"36-42";IF(AND(C3=2;C5=2);"43-49";"")))))))

I need more.... ;if(and C3=2;C5=3);"50-56";"" +++++
how do I do that???