Raise Flag: If and statement

Paige Luben

Trying to put in a formula that raising the flag if the end date is past the deadline and status is not marked as complete. This is the formula I have =IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete"), 1, 0)) but it is returning #UNPARSEABLE

Joanna Waligora

Looks like the AND closing bracket is misplaced. Would this work:

=IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete")), 1, 0)

Paige Luben

Thank you so much!!!

Joanna Waligora

Looks like the AND closing bracket is misplaced. Would this work:

=IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete")), 1, 0)

Paige Luben

Thank you so much!!!