I have written this formula but it isn't working - how would I write this to say if F2 is blank, then use the 2nd formula IF(C2<TODAY(),"Past Due",E2), otherwise, if F2 isn't blank, then mark "Complete"?
=if(F2=""),IF(C2<TODAY(),"Past Due",E2),"Complete")
=if(F2=""),IF(C2<TODAY(),"Past Due",E2),"Complete")