| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any number above 15 returns false when it should be true | Excel Worksheet Functions | |||
| An if statment tat returns a true blank | Excel Worksheet Functions | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| First part of "IF" function returns false even if true. ?? | Excel Worksheet Functions | |||
| True Or False, no matter what... it still displays the false statement | Excel Programming | |||
Threaded Mode
