Help shorten formula

[TiggerToo]

I need a little help with shortening this formula. The order does not matter which part is first or last, I just need to get shorter.

IF(AND($C$1="",INFO!H12=""),"",
If(AND($C$1="",INFO!H13=""),"",
IF(AND($C$1="ISO",INFO!H12=""),"",
IF(AND($C$1="ISO",INFO!H13=""),"",
IF(AND($C$1="ISO",INFO!H12="X"),"MAJOR",
IF(AND($C$1="ISO",INFO!H12="X"),"MINOR",
IF(AND($C$1="",INFO!H12="X"),"MAJOR ISO",
IF(AND($C$1="",INFO!H13="X"),"MINOR ISO",
IF(AND($C$1="Incoming",INFO!H12=""),"",
If(AND($C$1="Incoming",INFO!H13=""),"",
IF(AND($C$1="Incoming",INFO!H12="X"),"MAJOR ISO",
IF(AND($C$1="Incoming",INFO!H13="X"),"MINOR ISO")))))))))

Thanks
Walter

 

[jbeaucaire]

Give this a try:

=IF(Info!H12="X",IF(OR($C$1="",$C$1="Incoming"),"MAJOR ISO","MAJOR"),IF(Info!H13="X",IF(OR($C$1="",$C$1="Incoming"),"MINOR ISO","MINOR"),""))

 

[Scott Huish]

Perhaps:

=IF(INFO!H12&INFO!H13="","",CHOOSE(MATCH("X",INFO!H12:H13,0),"MAJOR","MINOR")&IF(C1<>"ISO"," ISO",""))