How to use All 4 Formulas together "IF AND NOT OR "
I have to create a formula that returns a value "1 or 0", so I use the IF statement. Now to satisfy multiple conditions, I am using the AND statement.
Also, to I want to check if the statement is not true, Hence I use the NOT function.
Based on this, the formula for my example is:
=IF(AND([Actual Complete]6 < TODAY(), NOT(Status6 = "Complete")), 1, 0)
Now I want to modify my formula such that :
The status could be either "Complete" or "Completed Late", how do I change the formula.
Thanks,
Comments

Without actually testing this out myself... try this and let me know if it works?
=IF(AND([Actual Complete]6 < TODAY(), OR(NOT(Status6 = "Complete"), Not(Status6 = "Completed Late"))), 1, 0)

No it does not work

It doesn't work, Returns as "Unparseable".
Could I be doing something wrong ?

Is your Actual Date column, a date column?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!