View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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