How to take "canceled" out of the equation

PR

Hello! I am trying to make it so an exclamation point appears if something is past due and not complete. Here is my current formula: 

=IF(AND(NOT(Status7 = "Complete"), TODAY() > [End Date]7), "High")

This is working great but it will have an exclamation point appear if something is past due and canceled. I would like for it to be blank if canceled as they won't complete that task. 

Thank you for your help! 

Nic Larsen

Try this:

=IF(status@row = "Cancelled", " ", IF(AND(NOT(status@row = "Complete"), TODAY() > [End Date]@row), "High"))

PR

Thank you so much! That worked great! 

I'm sorry, I had a second question: 

For the same formula, how would you add in so that a symbol wouldn't appear if the date is blank? 

Thank you again! 

Nic Larsen

Perfect... try this for the other question:

=IF(ISBLANK([End Date]@row), " ", IF(status@row = "Cancelled", " ", IF(AND(NOT(status@row = "Complete"), TODAY() > [End Date]@row), "High")))

PR

You are a hero! Thank you so much!