Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for looking up blank and/or date-filled cells- contingent
Hi:
Column A is called 'Receipt Deadline' (mo/dd/yr) Column B is called 'Actual Receipt Date'. (mo/dd/yr) Column C would be called 'Outstanding Receipts'?' (yes/no/'N/A') I want Column C to look in Column A and IF there is a date entered there, then look up column B and see if there is a date entered there as well. Then 1 of 3 scenarios will occur in Column C: 1. If there is a date in A but none in B, then I want it to return a value of 'Yes' in C. 2. If there is a date in both A and B, then I want it to return a value of 'No' in C. 3. If there are no dates in either A or B, I want it to return a value of 'N/A'. Can you help? thank you! Roady |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function contingent upon cell not being blank | Excel Worksheet Functions | |||
How to make a contingent formula shorter... | Excel Discussion (Misc queries) | |||
I need formula that will automatically count the filled cells. | Excel Discussion (Misc queries) | |||
Can i reduce my file that's 29 MB but filled with blank cells? | Excel Discussion (Misc queries) | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) |