IF is not carrying out the FALSE part

[derekbrown]

Hi,

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

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

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

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

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

Any help, much appreciatted.

Cheers

Dere

 

[JE McGimpsey]

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.

 

[sirknightly]

Derek,

I think you might be missing an equals sign. You have:

IF(DATEDIF($D$7,TODAY(),"M")14, ...

It should be:

IF(DATEDIF($D$7,TODAY(),"M")=14, ...

There may be a better way to perform the operation altogether, but I
wouldn't know without looking at your workbook as a whole.

Knightly

 

[derekbrown]

Thanks for the replies. May have been some confusion in the way that
outlined the formulas. Anyway, looked at it this morning and came u
with the solution. Formula should look like this:

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

Missing parenthisis. Grrrr! Knew it would be simple.

Cheers

Dere