Nested IF functions
Yes I see that now, thanks for the correction.
Regards!
Jean-Guy
"T. Valko" wrote:
If there are duplicate max values in K that will return an incorrect result.
Also, the LOOKUP in MATCH is redundant. Try it like this:
=(INDEX(I3:I14,MATCH(1E10,K3:K14))-LOOKUP(1E10,K3:K14))*0.05
--
Biff
Microsoft Excel MVP
"pinmaster" wrote in message
...
Hi,
Looks like your trying to substract the last value in K3:K14 from the
matching value in I3:I14 and multiply the result by .05, if that is the
case
them try this instead:
=(INDEX(I3:I14,MATCH(LOOKUP(9E+300,K3:K14),K3:K14, 0))-LOOKUP(9E+300,K3:K14))*0.05
HTH
Jean-Guy
"Chris" wrote:
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
|