Excel IF Statements 1

[rookster]

Excel will only allow me a maximum of 7 nested IF statements. I need 11 is there any way around this.

Cheers,
Ben

 

[VulcanJedi]

if you write the if statements in VBA I don't see how/why it'd limit you.... Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates others navigating through the threads / posts!

 

[Hasit]

You can extend to beyond 7 nested IF statements. Take a look at this :

http://www.cpearson.com/excel/nested.htm

 

[xlbo]

OR, if you are returning simple strings, you can use 1 VLOOKUP instead and just have a little table with your 11 answers... Rgds
~Geoff~

 

[rookster]

That website link from HAsit was very useful. I've solved my problem. Thanks again.

Regards,
Ben