If / Or statement

A

Annabelle

This formula works adds At Printer to O7.

=IF(W7>1/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?
 
B

Bob Phillips

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)
 
D

Dave Peterson

Be careful.

You may want:

=if(w7>date(2001,1,1),"at printer","")

Else you're comparing a division 1 divided by 1 divided by 2001.

Maybe...

=IF(AH7>DATE(2001,1,1),"In stock",IF(W7>DATE(2001,1,1),"At printer",""))

But I'm not sure how your if/or should work.

This is more like an And.
 
V

via135

thks Dave & Bob!

for correcting me!

-via135


Bob said:
Annabelle,

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

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
A

Annabelle

Thank you everyone. All of your suggestions/advice were quite helpful.

As "At Printer was the first location stop and "In Stock" was the final
destination, the solution I needed was =IF(AH7>DATE(2001,1,1),"In
stock",IF(W7>DATE(2001,1,1),"At printer","")).
 
Top