| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function in Excel
Hello, I want to write an "IF" Formula using dates and blank cells. ie if
Cell A2 is blank, use the date calculated in cell A1. However, if cell A" has a date, then I want to capture/use that date. I have tried <, etc, and it just doesn't like blank cells. Please help Thanks Mehul |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function in Excel
Do you mean
=IF(A2="",A1,A2) -- If this post helps click Yes --------------- Jacob Skaria "Superboy" wrote: Hello, I want to write an "IF" Formula using dates and blank cells. ie if Cell A2 is blank, use the date calculated in cell A1. However, if cell A" has a date, then I want to capture/use that date. I have tried <, etc, and it just doesn't like blank cells. Please help Thanks Mehul |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function in Excel
Brilliant - never thought of that. Thanks - it works a treat.
"Jacob Skaria" wrote: Do you mean =IF(A2="",A1,A2) -- If this post helps click Yes --------------- Jacob Skaria "Superboy" wrote: Hello, I want to write an "IF" Formula using dates and blank cells. ie if Cell A2 is blank, use the date calculated in cell A1. However, if cell A" has a date, then I want to capture/use that date. I have tried <, etc, and it just doesn't like blank cells. Please help Thanks Mehul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
Linear Mode
