IF statement
 

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


--
piglett51
------------------------------------------------------------------------
piglett51's Profile: http://www.excelforum.com/member.php...o&userid=27291
View this thread: http://www.excelforum.com/showthread...hreadid=467948

try

=IF(A1="not yet",DATEDIF(B1,C1,"d"),DATEDIF(B1,D1,"d"))



Ruthki


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=467948