how to over come limit of 7 imbedded if's

[wejofost]

There is a limit of 8(?) subsequent If statements within an IF statement. For example

Please Login or Register  to view this content.

I am using a Modulus 11 check digit and I need to match 11 possible results so need 11 IF tests. Can anyone suggest how to do it?

[Leith Ross]

Hello Wejofost,

Since you are using MOD 11 math to get the values from 0 to 10, and it looks like you want to return a column letter based on the result, you can simplify your code to this...

Please Login or Register  to view this content.

Capital "A" is ASCII value 65. Adding the modulus remainder then indexes you through columns A to J.

Sincerely,
Leith Ross

[daddylonglegs]

Try using CHOOSE...

=CHOOSE(H22+1,"A","B","C","D","E","F".,"G","H","I","J","K")

replace letters with anything you want

[wejofost]

To Lieth Ross and daddylonglegs,
Thank you. Two totally different but fully functional responses. How can I fail to achieve with such excellent support.
Lieth, your response is simple and shows lateral thinking. Works 100%.

daddylonglegs use of the CHOOSE function also works 100% and has introduced me to yet another level of functionality in Excel that I was unaware of.

I plan to use the CHOOSE methodology approach because I am trying to create a "secret" key that cannot be guessed. With my reading of the CHOOSE function I have the ability to specify and vary the sequence of the alpha matching characters which gives me a further level of encryption to deploy.

Thank you once again.
Wej Parry