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