Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a formula ignore empty cells?
I am using Excel in Office 2003. My spreadsheet contains a column (H) of
dates in the following format "2-Feb-06." Another column (J) contains the formula =H3+10, for example. In other words I want column J to populate with dates 10 days past the dates entered in column H. In the above example, the cell J3 contains "12-Feb-06." This is working like a charm exept for instances in which the cell in column H is blank. When this happens the date "10-Jan-00" appears in column J because it is adding 10 days to nothing (empty cell). Is there any way I can utilize this formula to keep a cell in J blank if the corresponding cell in H is blank? Any help would be greatly appreciated! Thanks, Melissa |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a formula ignore empty cells?
Try this:
=IF(H3<"",H3+10,"") HTH, Elkar "Melissa" wrote: I am using Excel in Office 2003. My spreadsheet contains a column (H) of dates in the following format "2-Feb-06." Another column (J) contains the formula =H3+10, for example. In other words I want column J to populate with dates 10 days past the dates entered in column H. In the above example, the cell J3 contains "12-Feb-06." This is working like a charm exept for instances in which the cell in column H is blank. When this happens the date "10-Jan-00" appears in column J because it is adding 10 days to nothing (empty cell). Is there any way I can utilize this formula to keep a cell in J blank if the corresponding cell in H is blank? Any help would be greatly appreciated! Thanks, Melissa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
continuing formula when cells are empty | Excel Worksheet Functions | |||
Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Trendlines to ignore empty cells | Charts and Charting in Excel | |||
excluding cells from the formula when empty | Excel Worksheet Functions |