C
Chris
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(K10<>"",if(K9<>"",if(K8<>"",if(K7<>"",if(K6<>"",if(K5<>"",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
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(K10<>"",if(K9<>"",if(K8<>"",if(K7<>"",if(K6<>"",if(K5<>"",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