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