Using IF to fill cells with TEXT to show staus based on multiple criteria

[karstens]

This is probably an easy fix, but I can't seem to get it right;

E2 is an install date
F2 is a disconnect date
G2 is where I would like the status to show

I am tracking circuits and need to show what we have as Active or Vacant circuits.
I would like all of G to show vacant, until an install date goes into E2.
So if E2, has an install date in it, then obviously G2 needs to change from Vacant to Active.
At some point, F2 will become populated with a disconnect date, so both E2 and F2 will have dates in them, making this circuit now Vacant again.

So in summary:
Initially the status cell (G2) should read Vacant
Once E2 indicates an install by being populated a date, the status cell (G2) should change to Active.
If that circuit gets disconnected whereas F2 is populated with a date, the status cell (G2) should switch back to Vacant.

I thank anyone in advance who can help me!

[benishiryo]

hi karstens, you can try:
=IF(OR(E2="",F2<>""),"Vacant","Active")

[karstens]

Thank you very much! That works great.
I have never used the OR, so that was very helpful. Thanks again.

[karstens]

Your formula works great...but I need to add another criteria:

E2 is an install date
F2 is a disconnect date
G2 is where I would like the status to show

If E2 is populated, G2 should say "Active"
If F2 is populated, G2 should say "Disc"
If neither is populated, G2 should say "Vacant"

Thanks again for any assistance.

[benishiryo]

you could try this:
=IF(AND(E2="",F2=""),"Vacant",IF(F2<>"","Disc","Active"))

no problem~ and thanks for the rep

[karstens]

Thanks again.....