Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine 2 different SUMPRODUCT criteria into one cell????? | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |