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")

--
Gary's Student
gsnu200704


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