| 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, |
| 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) | |||
Threaded Mode
