I have 4 columns:
Col B indicates if Trained - Yes = X, No = "" (blank)
Col D indicates Phase 1, 2, 3, 4, 5, or 6
Col E indicates Back-Up Phase 1, 2, 3, 4, 5, 6, or "" (blank)
In Col F I want a formula that will do the following:
If B2 contains an X, F2=0
If B2 is blank, and...
E2 is blank, F2=0
D2 is Less Than or Equal to E2, F2=D2
D2 is Greater Than E2, F2=E2

I have the following formula that works for everything EXCEPT those times
when F2 should equal E2 or 0: =IF(AND(OR(D2<=E2,D2=E2),B2=""),D2,"0")
Not sure where to go from here. Can you help?

Thank you!
Carol
I've got an if/and formula that is doing everything
--
Carol