If / Or statement
Be careful.
You may want:
=if(w7date(2001,1,1),"at printer","")
Else you're comparing a division 1 divided by 1 divided by 2001.
Maybe...
=IF(AH7DATE(2001,1,1),"In stock",IF(W7DATE(2001,1,1),"At printer",""))
But I'm not sure how your if/or should work.
This is more like an And.
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?
--
Dave Peterson
|