IF statement

P

piglett51

Seems like everyone is working with conditional formatting today!

I am trying to work on an on time analysis. I need to subtract one dat
from another to ge tthe days late. However I also have a volume of "No
Yet". I want to say:

If A1="Not Yet" (B1-C1) otherwise (B1-D1)

How do I do that?

Thank
 
Top