View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default How to simplify "multiple if" formula

I think the problem is that once you have set a cell to blank then
EDATE( ... ) will return an error if it acts upon that cell.

Try this (a variation of your second formula):

=IF(I4="";"";IF(EDATE(I4;1)$D$4;"";EDATE(I4;1)))

and then copy this across.

Hope this helps.

Pete