Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return empty string value if cell is blank
I think I understand how to do this but need help with the exact formula. If
I want to do a date function that adds 6 months to a cell value I have added teh forumula =DATE(YEAR(E13),MONTH(E13)+6,DAY(E13)), however some of the cells have no values in the E column yet, so they bring back erroneous information. Can't I use some sort of an If("", ) statement to only bring back values for cells which are not empty?? Thanks in advance, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
return empty string value if cell is blank
The following formula will do the trick:
=IF(ISBLANK(E13),"",DATE(YEAR(E13),MONTH(E13)+6,DA Y(E13))) Hope this helps. -- Kevin Backmann "Nat" wrote: I think I understand how to do this but need help with the exact formula. If I want to do a date function that adds 6 months to a cell value I have added teh forumula =DATE(YEAR(E13),MONTH(E13)+6,DAY(E13)), however some of the cells have no values in the E column yet, so they bring back erroneous information. Can't I use some sort of an If("", ) statement to only bring back values for cells which are not empty?? Thanks in advance, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
return empty string value if cell is blank
That is perfect .. thanks a bunch.
"Kevin B" wrote: The following formula will do the trick: =IF(ISBLANK(E13),"",DATE(YEAR(E13),MONTH(E13)+6,DA Y(E13))) Hope this helps. -- Kevin Backmann "Nat" wrote: I think I understand how to do this but need help with the exact formula. If I want to do a date function that adds 6 months to a cell value I have added teh forumula =DATE(YEAR(E13),MONTH(E13)+6,DAY(E13)), however some of the cells have no values in the E column yet, so they bring back erroneous information. Can't I use some sort of an If("", ) statement to only bring back values for cells which are not empty?? Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if zero, then return blank/empty | Excel Worksheet Functions | |||
return an empty string in VBA | Excel Discussion (Misc queries) | |||
Return an empty or blank cell value? | Excel Worksheet Functions | |||
Return an empty cell | Excel Discussion (Misc queries) | |||
Copy a string text to cell if another cell not empty | Excel Discussion (Misc queries) |