If / Or statement

[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?

[via135]

hi

try this

=IF(W7>1/1/2005,"At Printer",IF(AH7>1/1/2001,"In Stock",""))

-via135

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?

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

"Annabelle" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[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.

Annabelle wrote:
>
> 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?

--

Dave Peterson

[via135]

thks Dave & Bob!

for correcting me!

-via135

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[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","")).