I don't have Excel 2007 so I'm trying to figure this out with the nested
limit of previous versions.

Hard to figure out what you're trying to do with this. You don't need to use
this on every separate condition: *0.05. You can put that outside of the
formula and it will still do the same thing.

=IF(...IF(...IF)...)))*0.05

If all the cells in the range K4:K14 <"" then subtract K3 from I3. If any
cell (other than K14, if K14 ="" then 0) is "" then subtract that cell from
the corresponding cell in range I. That's what your formula would do if it
was working but that doesn't make any sense (to me).

Perhaps you should explain it. I'm sure a better formula can be written to
do what you want.

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
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