Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 3 columns of dates (A1, B1, C1).
Several different scenarios: 1. If A1 is blank, but B1 & C1 are populated, I want to put the result in D1. 2. If B1 is blank, but A1 & C1 are populated, I want to put the result in D1. 3. If C1 is blank, but A1 & B1 are populated, I want to put the result in D1. 4. If A1 & B1 are blank, I want to put "N/A" in D1. 5. If A1 & C1 are blank, I want to put "N/A" in D1. 6. If B1 & C1 are blank, I want to put "N/A" in D1. Why are there 3 date fields you ask, the powers that be want it that way, lucky me. Thanks, Mendz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL should let me establish unlimited numbers of columns. | Excel Discussion (Misc queries) | |||
Caculating Columns Between Certain Dates | New Users to Excel | |||
Formula for calc diff between two julian dates | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Convert three separate columns of values to dates | Excel Worksheet Functions |