Menu

IF statement returns false when statment is True

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

Claus Busch is offline

external usenet poster

Posts: 3,872

Default

IF statement returns false when statment is True

Hi Don,

Am Wed, 3 Jun 2015 05:14:30 -0700 (PDT) schrieb :

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

you have to put the conditions into the formula in the order of your
priority. The conditions are checked from left to right and if the first
condition is TRUE you get the output for this condition. Following
conditions will not be checked.
Try:
=IF(L95="District Did Not Investigate","PFM Withdrawn",IF(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(AND(S95="",TODAY()Q95),TODAY()-Q95&" "&""&"Days Past Due",IF(AND(S95="",TODAY()<Q95),"Investigating PFM")))))))

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Any number above 15 returns false when it should be true	tlaurie777	Excel Worksheet Functions	2	September 26th 07 05:02 PM
An if statment tat returns a true blank	D	Excel Worksheet Functions	4	August 29th 07 02:48 PM
If Statement returns true when false?	Eric	Excel Discussion (Misc queries)	3	September 11th 06 01:58 PM
First part of "IF" function returns false even if true. ??	Bill R	Excel Worksheet Functions	4	September 5th 05 08:11 PM
True Or False, no matter what... it still displays the false statement	rocky640[_2_]	Excel Programming	2	May 13th 04 04:57 PM

All times are GMT +1. The time now is 07:16 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement