If Or?

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 on
date from another to ge tthe days late. However I also have a volum
of "Not Yet". I want to say:

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

How do I do that?

Thank
 
K

kk

Hi

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

Hope this help.



in message
Seems like everyone is working with conditional formatting today!

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

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

How do I do that?

Thanks
 
Top