Try this in C2 and fill down:

=IF(D2>0,"Complete",IF(E2>0,"Referred",IF(F2>0,"Filed","WIP")))

- Moo