hi

try this

=IF(W71/1/2005,"At Printer",IF(AH71/1/2001,"In Stock",""))

-via135




Annabelle Wrote:
This formula works adds At Printer to O7.

=IF(W71/1/2001,"At Printer","")

Having difficulty adding another possibility: If W7 1/1/2001, "At
Printer","" Or AH 1/1/2001, "In Stock", ""

In english - if there is a date in W7, then insert "At Printer or if
there is a date in AH7, then insert "In Stock".


Can you assist?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=514474