Project Percentage Tracking Formulas - HELP PLEASE!!

I have no foggiest idea what shall be in empty cells K44, M44 etc, so will not comment on the last formula (for column J).

Let's start from what is visible:

Columns F and G formulas work well.
For cell K3 , I'd suggest:

Formula:

=IF(H3<>"","Completed",IF(AND(F3<>"",G3<>""),(F3-G3)/F3,""))

and copy down

It can be expanded to check other special conditions - like not started yet

Formula:

=IF(H3<>"","Completed",IF(AND(F3<>"",G3<>""),(F3-G3)/F3,IF(AND(D3<>"",D3>=TODAY()),"Not started","")))

etc.

Or may be this column only percentage shall be shown, so

Formula:

=IF(H3<>"",1,IF(AND(F3<>"",G3<>""),(F3-G3)/F3,0))

and comments for special cases shall go to column J?

How do you define the overall percentage

Based on posts 3 and 5 I placed the following formula in cell G13: =(SUM(G3:G12))/(SUM(F3:F12))
I placed the following formula in J3 and copied down to J12:

Formula:

=IF(E3="","",IF(TODAY()/F3>=G$13,"On Track",IF(TODAY()/F3>G$13-0.1,"At Risk","Off Track")))

See if they produce the expected results and if not let us know what results you do expect and some rational as to why.