I need to calculate % Complete

StephMac

Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past.

Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row)

What I am trying to write but won’t work: =IF(Status@row= “Complete”, 100%, (=TODAY()-[Start Date]@row/[End Date]@row-[Start Date]@row))

Help! How can I get this to work??

bisaacs

Is the % completed supposed to just calculate what % of time has passed between start date and end date then?

also, I think you'd need to remove the "=" sign in front of TODAY in the IF statement. What error are you currently getting?