Problem of having more than 7 IF statement

  • Thread starter Thread starter O Puatu
  • Start date Start date
O

O Puatu

Excel 2000 has a limitation of seven IF statements. If
you need to have eight IF statement, it works if seven
are embedded, as stated in the MS KB Article 214154.

My question is isn't there any other way to have more
than eight IF statement? Here's my formula, which only
works up to eight IF statement (cells b15 thru I15):

=IF(B16='DISTRICT 10'!B15,'DISTRICT 10'!B16,IF('TOP SIX'!
B16='DISTRICT 10'!C15,'DISTRICT 10'!C16,IF('TOP SIX'!
B16='DISTRICT 10'!D15,'DISTRICT 10'!D16,IF('TOP SIX'!
B16='DISTRICT 10'!E15,'DISTRICT 10'!E16,IF('TOP SIX'!
B16='DISTRICT 10'!F15,'DISTRICT 10'!F16,IF('TOP SIX'!
B16='DISTRICT 10'!G15,'DISTRICT 10'!G16,IF('TOP SIX'!
B16='DISTRICT 10'!H15,'DISTRICT 10'!H16,IF('TOP SIX'!
B16='DISTRICT 10'!I15,'DISTRICT 10'!I16))))))))

Thanks!
O
 
O Puatu,

You can have more than seven "IFs" by using-

-Insert -Name -Define

Insert one name inside the other.

regards,

JohnI
 
Back
Top