Excel 2007 claims to allow up to 64 nested functions, but I am getting an
error in a spread sheet with much less than that (but more than the 10
previously allowed). Excel is indicating that I must use a different file
format, but it is not clear which one I must use - binary, "default" (which I
have tried), macro enabled, etc. Which one of these is the 2007 format that
will allow more nested functions?

The function I am trying to nest is:

=IF(K14<"",if(K13<"",if(K12<"",if(K11<"",if(K1 0<"",if(K9<"",if(K8<"",if(K7<"",if(K6<"",if(K 5<"",if(K4<"",((l3-k3)*.05),((l4-k4)*.05),((l5-k5)*.05),((l6-k6)*.05),((l7-k7)*.05),((l8-k8)*.05),((l9-k9)*.05),((l10-k10)*.05),((l11-k11)*.05,((l12-k12)*.05,((l13-k13)*.05),((l14-k14)*.05),0)

Perhaps this would be better served as an array function?

Regards,

Chris