If Or?

[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

 

[Guest]

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

 

[Per Erik Midtrød]

I think this is what you need:
IF(A1<NOW();B1-C1;B1-D1)


Per Erik

 

[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

 

[Ruthki]

thread posted twice see answer on other thread