How to add an and/or statement into a sheet formula
I'm a total noob when it comes to formulas and I was hoping someone could assist me with figuring out how to add an "and/or" portion into this formula:
=IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0)
Within the "Complete" portion I would like an "and/or" statement for "Cancelled". So that the "At Risk" column will not be flagged if the date isn't past due, or if the "Status" column is "Complete" or "Cancelled".
Help Article Resources
Check out the Formula Handbook template!