LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Suz
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to combine 2 different SUMPRODUCT criteria into one cell????? Tourcat Excel Worksheet Functions 4 February 10th 05 07:25 AM
"criteria" in a sumif refering to the value in another cell mark Excel Discussion (Misc queries) 1 January 31st 05 07:39 PM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"