Using IF when more than one cell contains criteria
 

Hello and an advance "Thank you!" to anyone who can help.

I need a formula that will tell me if I have an upcoming demand for a
product (90 days from today's date), but no PO to match.

Example: Today is 2/16/05 - Cell a6 contains my product due date of
5/16/05. Cell b6 is empty (should be PO #).

My current formula only tells me the date the PO should be in my hands
(Sheet1!A$1 references today's date).

=IF('2005 Forecast'!A6Sheet1!A$1,+'2005 Forecast'!A6-90," ")

How do I modify the above formula to include the cell that should contain
the PO # and only give results if that cell (B6) is blank?

Perhaps I shouldn't be using the IF function?

Thanks again - Sue

Sue,

You don't really have a choice about the IF

=IF(AND('2005 Forecast'!A6Sheet1!A$1,'2005 Forecast'!C6<"PO"),'2005
Forecast'!A6-90," ")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Suz" wrote in message
...
Hello and an advance "Thank you!" to anyone who can help.

I need a formula that will tell me if I have an upcoming demand for a
product (90 days from today's date), but no PO to match.

Example: Today is 2/16/05 - Cell a6 contains my product due date of
5/16/05. Cell b6 is empty (should be PO #).

My current formula only tells me the date the PO should be in my hands
(Sheet1!A$1 references today's date).

=IF('2005 Forecast'!A6Sheet1!A$1,+'2005 Forecast'!A6-90," ")

How do I modify the above formula to include the cell that should contain
the PO # and only give results if that cell (B6) is blank?

Perhaps I shouldn't be using the IF function?

Thanks again - Sue

Bob,

Thank you for responding so quickly! I had to tweak your formula a bit as
it returned results only for rows where both cells were blank instead of the
PO cell only, but your help gave me a running start.

Much appreciated!

Sue

"Bob Phillips" wrote:

Sue,

You don't really have a choice about the IF

=IF(AND('2005 Forecast'!A6Sheet1!A$1,'2005 Forecast'!C6<"PO"),'2005
Forecast'!A6-90," ")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Suz" wrote in message
...
Hello and an advance "Thank you!" to anyone who can help.

I need a formula that will tell me if I have an upcoming demand for a
product (90 days from today's date), but no PO to match.

Example: Today is 2/16/05 - Cell a6 contains my product due date of
5/16/05. Cell b6 is empty (should be PO #).

My current formula only tells me the date the PO should be in my hands
(Sheet1!A$1 references today's date).

=IF('2005 Forecast'!A6Sheet1!A$1,+'2005 Forecast'!A6-90," ")

How do I modify the above formula to include the cell that should contain
the PO # and only give results if that cell (B6) is blank?

Perhaps I shouldn't be using the IF function?

Thanks again - Sue

Glad to help Sue. I thought I didn't quite get it, but it all worked out.

Bob


"Suz" wrote in message
...
Bob,

Thank you for responding so quickly! I had to tweak your formula a bit as
it returned results only for rows where both cells were blank instead of
the
PO cell only, but your help gave me a running start.

Much appreciated!

Sue

"Bob Phillips" wrote:

Sue,

You don't really have a choice about the IF

=IF(AND('2005 Forecast'!A6Sheet1!A$1,'2005 Forecast'!C6<"PO"),'2005
Forecast'!A6-90," ")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Suz" wrote in message
...
Hello and an advance "Thank you!" to anyone who can help.

I need a formula that will tell me if I have an upcoming demand for a
product (90 days from today's date), but no PO to match.

Example: Today is 2/16/05 - Cell a6 contains my product due date of
5/16/05. Cell b6 is empty (should be PO #).

My current formula only tells me the date the PO should be in my hands
(Sheet1!A$1 references today's date).

=IF('2005 Forecast'!A6Sheet1!A$1,+'2005 Forecast'!A6-90," ")

How do I modify the above formula to include the cell that should
contain
the PO # and only give results if that cell (B6) is blank?

Perhaps I shouldn't be using the IF function?

Thanks again - Sue