IF is not carrying out the FALSE part
 

Hi,

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!!

Any help, much appreciatted.

Cheers

Derek


--
derekbrown
------------------------------------------------------------------------
derekbrown's Profile: http://www.excelforum.com/member.php...o&userid=21253
View this thread: http://www.excelforum.com/showthread...hreadid=397852

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!!

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

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

=IF($D$7="",IF(AND('Insight Data'!$A$7="Y",ISNUMBER('Insight
Data'!AI7)),'Insight
Data'!AI7*)*,IF(DATEDIF($D$7,TODAY(),"M")<14,CHOOS E(13-COUNTBLANK($N$7: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),""))

Missing parenthisis. Grrrr! Knew it would be simple.

Cheers

Derek


--
derekbrown
------------------------------------------------------------------------
derekbrown's Profile: http://www.excelforum.com/member.php...o&userid=21253
View this thread: http://www.excelforum.com/showthread...hreadid=397852