Excel If Statements - getting over the Excel limit of 7

[Peter]

I am trying to create a conditional statement with 17 IFs. I started needing
to do 11 Ifs. I got over the Excel limit of 7 by identifying a cell in the
last element of the first string of 4 IFs in which there was a further string
with 7 IFs. However I now need to expand this to 17 IFs. I tried the same
technique of creating a third string with 6 more IFs and identifying this in
the last condition of the second string. It didn't work.

Any ideas.

 

[Niek Otten]

Look here:

http://www.j-walk.com/ss/excel/usertips/tip080.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to create a conditional statement with 17 IFs. I started needing
| to do 11 Ifs. I got over the Excel limit of 7 by identifying a cell in the
| last element of the first string of 4 IFs in which there was a further string
| with 7 IFs. However I now need to expand this to 17 IFs. I tried the same
| technique of creating a third string with 6 more IFs and identifying this in
| the last condition of the second string. It didn't work.
|
| Any ideas.

 

[Roger Govier]

Hi Peter

Maintaining formulae with that number of IF's (utilising various tricks to
get over Excel's limit of 7) can be a nightmare to maintain.
Can you post an example of what you are trying to do, as it may be that a
Lookup table would be a much better option for you.

 

[Peter]

Thanks folks. Got it to work.