Problem of having more than 7 IF statement

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simplifying a formula 3
Automate Import Excel Info 2
Code to long - needs help on "if" statements 0
excel functions: profit/loss calculations 0
Money "In" Money "Out" Formula 6
Userform help please 5
Macro hangs my excel (not responding) 3
Run-time error 1004 Method "Range of object_global failed 5

Top