View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Limits on nested formulas

May be you are working on a file created in 2003 format - xls extension.

Save it as an xlsx file then you will get the increased numbers of If

"Jerry Edge" wrote:

I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I
should be able to nest 64 formulas. Am i reading that wrong or is something
else going on?
--
Jerry Edge