excel learn london - IF statements

Dear Nick

Any version prior to Excel 2007 has a limit of 7 IF statements that can be used.

Excel 2007 Microsoft has increased it to 64 IF Statements.

Normally it is suggested that you use VBA coding if you have more than 7 If Statements that you wish to use in the same cell.

But there is, however, a way around using more than 7 If Statements without the knowledge of VBA by using the naming ranges.

Please post your specific question containing more than 7 If statements and I