Formula for "Overdue" in Status Column

Irishalum2002

I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line.  i've read a lot of the other posts but none of the formulas seem to apply or work when I input them.  Please let me know your thoughts.  Thank you!

Paul Newcome

Give this a whirl...

 

=IF([% Complete]@row = 1, "Complete", IF([End Date]@row < TODAY(), "Overdue", IF([% Complete]@row = 0, "Pending", "In Progress")))