thks Dave & Bob!

for correcting me!

-via135


Bob Phillips Wrote:
Annabelle,

Your original formula was flawed as it didn't properly test a date (put
any
date and see), but this caters for the amend

=IF(W7--"2001-01-01","At Printer",IF(AH7--"2001-01-01","In
Stock",""))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Annabelle" wrote in message
oups.com...
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