IF is not carrying out the FALSE part
- From: derekbrown <derekbrown.1u6gn7_1124733985.2692@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 22 Aug 2005 13:02:47 -0500
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(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),"")))
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?action=getinfo&userid=21253
View this thread: http://www.excelforum.com/showthread.php?threadid=397852
.
- Follow-Ups:
- Re: IF is not carrying out the FALSE part
- From: sirknightly
- Re: IF is not carrying out the FALSE part
- From: JE McGimpsey
- Re: IF is not carrying out the FALSE part
- Prev by Date: Re: I'm Having Problems with EOMONTH
- Next by Date: Re: I'm Having Problems with EOMONTH
- Previous by thread: Getpivotdata - Excel 2000 vs. Excel 2002 and later
- Next by thread: Re: IF is not carrying out the FALSE part
- Index(es):
Relevant Pages
|
