If statements

[Scottie31]

Is it possible to create a formula with more than 7 If Statements in Excel? If not, what are my options?

Thanks,

 

[boblarson]

You could create a formula in VBA using a select case statement and return the value to the cell that way.

 

[qafself]

yes it is possible, check out this site

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

Regards

 

[boblarson]

yes it is possible, check out this site

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

Regards

An interesting solution, although I think for sanity's sake I would probably resort to using a VBA Function with a Select Statement just for the simplicity of maintenance of being able to view everything in its entirety and not get totally confused as to what part is what. But, thanks for a good alternative solution.

 

[qafself]

I agree it's it not pretty - another possible way round could be using a VLOOKUP table but, without knowing the data format, one can't be sure.

In general, I find that there's usually a way to avoid huge nested IFs.

Regards