Peter has attended:
Excel Intermediate course
Excel Advanced course
Nesting in Excel
For any cell, a pop-up appears in Excel 2007 when my cell exceeds 7 nests in the function (made up of Ifs and AND functions). I'm saving the spreadsheet as a Excel 97-2004 compatible file. Is there anyway round this? And do later versions of Excel allow a greater degree of nesting?
RE: Nesting in Excel
Hello Peter,
Thank you for your question regarding nesting functions in Excel.
Excel 2003 and all previous versions only allow 7 nested functions. Excel 2007 and on allow up to 64 nested functions. If you want to use more than 7 nested functions, therefore, you will not be able to save the file as an Excel 97-2003 version.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
