help with the "if" commando

[Guest]

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

 

[Guest]

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

Dave

 

[Guest]

You don't need 7 IFs. You don't even need one IF:

=CHOOSE(4*(C3-1)+C5,"1-7","8-14","15-21","22-28","29-35","36-42","43-49","50-56")