What is wrong with this formula?

Question

I'm trying to change the status based on % complete column: =IF([Percent Complete]@row = 1, "Complete", IF([Percent Complete]@row = 0, "Not Started", IF(AND([Percent Complete]@row < 1, [Finish Date]@row < TODAY()), "Delayed", IF(AND([Percent Complete]@row < 0.5, [Finish Date]@row <= TODAY(5)), "At Risk", IF(AND([Percent Complete]@row < 1, [Finish Date]@row > TODAY(7)), "In Progress", IF(AND([Percent Complete]@row > 0.5, [Finish Date]@row < TODAY(7)), "In Progress", “"")))))) Thank you!!

Christian Graf · Accepted Answer

=IF([Percent Complete]@row = 1, "Complete", IF([Percent Complete]@row = 0, "Not Started", IF(AND([Percent Complete]@row < 1, [Finish Date]@row < TODAY()), "Delayed", IF(AND([Percent Complete]@row < 0.5, [Finish Date]@row <= TODAY(5)), "At Risk", IF(AND([Percent Complete]@row < 1, [Finish Date]@row > TODAY(7)), "In Progress", IF(AND([Percent Complete]@row > 0.5, [Finish Date]@row < TODAY(7)), "In Progress", "")))))) Too many quotation marks at the end.