Multiple "IF" statements in one cell

[camioneur]

No matter where I look I come up with the same answer and I'm baffled!

The maximum number of nested IF's in one excel cell is supposed to be 7. I currently use 12 in one cell and it still works. Does this mean the maximum is not 7 or is my IF statement not nested. eg below which works perfectly, Windows 7, MS Office 2007

=IF(C38="Graham","9",IF(C38="Nick","61n",IF(C
38="Paul","61p",IF(C38="McGoo","10",IF(C38="K
ayden","kp",IF(C38="JD","11",IF(C38="pete","1
1",IF(C38="",0,IF(C38="bill","br",IF(C38="baa
rda","ba",IF(C38="Bob","o1",IF(C38="coxy","o1
",))))))))))))

[bibblebub]

Help in Excel 2010 says: Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests...

[ChuckFickens]

Not sure where you got 7 from, it was 8 in excel 97/2000/2003 and went up to 64 in 2007.

[ABerrant]

7 nested levels of functions would be got from Microsoft's 'specifications and limits' for Excel 2003

http://office.microso...mits-HP005199291.aspx

...and was indeed increased to 64 nested levels for 2007

http://office.microso...mits-HP010073849.aspx

[camioneur]

thank you, all is now clear