Not sure *which* "false part" you're talking about, but in the case of
the first conditional, you don't have a FALSE branch - everything
following the first comma, up until the last right paren, is part of the
TRUE branch.



In article ,
derekbrown
wrote:

I am having a problem with the formula below. It does not carry out the
false part of the statement, i.e;

IF(DATEDIF($D$7,TODAY(),"M")<14,CHOOSE(13-COUNTBLANK(N7:Y7),'Insight
Data'!$W$7,'Insight Data'!$X$7,'Insight Data'!$Y$7,'Insight
Data'!$Z$7,'Insight Data'!$AA$7,'Insight Data'!$AB$7,'Insight
Data'!$AC$7,'Insight Data'!$AD$7,'Insight Data'!$AE$7,'Insight
Data'!$AF$7,'Insight Data'!$AG$7,'Insight Data'!$AH$7,'Insight
Data'!$AI$7)

Instead it simply returns FALSE as a value. Whole formula is posted
below:

=IF(D7="",IF(AND('Insight Data'!A7="Y",ISNUMBER('Insight
Data'!AI7)),'Insight
Data'!AI7,IF(DATEDIF($D$7,TODAY(),"M")<14,CHOOSE(1 3-COUNTBLANK(N7:Y7),'Insight
Data'!$W$7,'Insight Data'!$X$7,'Insight Data'!$Y$7,'Insight
Data'!$Z$7,'Insight Data'!$AA$7,'Insight Data'!$AB$7,'Insight
Data'!$AC$7,'Insight Data'!$AD$7,'Insight Data'!$AE$7,'Insight
Data'!$AF$7,'Insight Data'!$AG$7,'Insight Data'!$AH$7,'Insight
Data'!$AI$7),"")))

Anybody any ideas? I am sure it's simple but I have been looking at it
for a while now and the answer is eluding me!!