| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Empty Cell
How can I show an empty result if Cell E4 is empty
=DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)) many thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty Cell
Hi CP,
Do you mean ... =if(E4="","", DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4))) Wkr, JP "CP" wrote in message ... How can I show an empty result if Cell E4 is empty =DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)) many thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty Cell
=if(E4="","",DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))
"CP" wrote: How can I show an empty result if Cell E4 is empty =DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)) many thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty Cell
Thanks for that
"Sean Timmons" wrote: =if(E4="","",DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4))) "CP" wrote: How can I show an empty result if Cell E4 is empty =DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)) many thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Empty Cell
Thanks for that
"JP Ronse" wrote: Hi CP, Do you mean ... =if(E4="","", DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4))) Wkr, JP "CP" wrote in message ... How can I show an empty result if Cell E4 is empty =DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)) many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Linear Mode
