Multiple cells to get value into one cell

[Bunny Screen]

Hi, I have a spreadsheet that is used to know the status of a job. Depending on which of three columns a date is in it means a different status.

I can get the status where there are no dates (using a counta formula) but it's the other parts I can only partially get to work.

See example - any help is apprceiated!

[Moo the Dog]

Try this in C2 and fill down:

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

- Moo

[Bunny Screen]

Moo, thank you! This is my 1st time to use this site so thanks!!

Could I ask for one more bit to put into the formula? ...

If there is a date in two columns this would also make the status complete?

I have reattached with example.

B.

[Moo the Dog]

Try:

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

- Moo

[Bunny Screen]

thank you