Remember Me?

#1
June 3rd 15, 01:14 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2015 Posts: 5
IF statement returns false when statment is True

I have the following formula:

=IF(AND(S95<"",TODAY()<S95),"Investigating PFM",IF(AND(S95<"",TODAY()S95,T95=""),TODAY()-S95&" "&""&"Days Past Due",IF(AND(S95="",T95<""),"Investigation Report Received",IF(AND(S95<"",T95<""),"Investigation Report Received",IF(L95="District Did Not Investigate","PFM Withdrawn",IF(AND(S95="",TODAY()Q95),TODAY()-Q95&" "&""&"Days Past Due",IF(AND(S95="",TODAY()<Q95),"Investigating PFM")))))))

This statement return false when in reality it is true. Why?
IF(L95="District Did Not Investigate","PFM Withdrawn"

#2
June 3rd 15, 01:40 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,872
IF statement returns false when statment is True

#3
June 3rd 15, 02:04 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2015 Posts: 5
IF statement returns false when statment is True

Claus

Thanks very much for the help but I get the same answer. The formula is recognizing L95 as false when in reality it is true. In l95 I have a drop down list that I make a selection from but for whatever reason the formula is returning a result of false.

On Wednesday, June 3, 2015 at 8:14:32 AM UTC-4, wrote:
I have the following formula:

=IF(AND(S95<"",TODAY()<S95),"Investigating PFM",IF(AND(S95<"",TODAY()S95,T95=""),TODAY()-S95&" "&""&"Days Past Due",IF(AND(S95="",T95<""),"Investigation Report Received",IF(AND(S95<"",T95<""),"Investigation Report Received",IF(L95="District Did Not Investigate","PFM Withdrawn",IF(AND(S95="",TODAY()Q95),TODAY()-Q95&" "&""&"Days Past Due",IF(AND(S95="",TODAY()<Q95),"Investigating PFM")))))))

This statement return false when in reality it is true. Why?
IF(L95="District Did Not Investigate","PFM Withdrawn"

#4
June 3rd 15, 02:22 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,872
IF statement returns false when statment is True

#5
June 3rd 15, 03:23 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2009 Posts: 5
IF statement returns false when statment is True

Claus

Thanks very much for your help. That was the problem. I had extra spaces at the end of the text in L95 that was throwing off the formula. Again thanks very much.

Don

On Wednesday, June 3, 2015 at 8:14:32 AM UTC-4, Don B wrote:
I have the following formula:

=IF(AND(S95<"",TODAY()<S95),"Investigating PFM",IF(AND(S95<"",TODAY()S95,T95=""),TODAY()-S95&" "&""&"Days Past Due",IF(AND(S95="",T95<""),"Investigation Report Received",IF(AND(S95<"",T95<""),"Investigation Report Received",IF(L95="District Did Not Investigate","PFM Withdrawn",IF(AND(S95="",TODAY()Q95),TODAY()-Q95&" "&""&"Days Past Due",IF(AND(S95="",TODAY()<Q95),"Investigating PFM")))))))

This statement return false when in reality it is true. Why?
IF(L95="District Did Not Investigate","PFM Withdrawn"

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post tlaurie777 Excel Worksheet Functions 2 September 26th 07 05:02 PM D Excel Worksheet Functions 4 August 29th 07 02:48 PM Eric Excel Discussion (Misc queries) 3 September 11th 06 01:58 PM Bill R Excel Worksheet Functions 4 September 5th 05 08:11 PM rocky640[_2_] Excel Programming 2 May 13th 04 04:57 PM

All times are GMT +1. The time now is 05:25 PM.