If / Or statement
 

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?

If / Or statement
 

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?

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

If / Or statement
 

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

If / Or statement
 

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

If / Or statement
 

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(AH7DATE(2001,1,1),"In
stock",IF(W7DATE(2001,1,1),"At printer","")).