Hi Roger, Jim,
Actually the limit in Excel 2007 is 64 levels, but of course even that is far too many to be able to understand a formula.
The limit applies to all functions and mixtures of functions, not just IF's. With just IF's, even 7 levels exceed my capability
for understanding!
I assume it is only used because users are not familiar with the alternatives.
If so, they might benefit from looking he
http://www.j-walk.com/ss/excel/usertips/tip080.htm
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message ...
| Hi Jim
|
| Yes you can.
| I think the limit is now 256, but I don't think I would want to use the
| limit!!!<bg
|
| --
| Regards
| Roger Govier
|
|
|
| "Jim May" wrote in message
| ...
| Can you now enter more than 7 nested If's in this version?
|
|