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