View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
jimar
 
Posts: n/a
Default I need a formula

Thanks. This works perfectly.

" wrote:

"jimar" wrote:
There will never be a date in both columns on the same row.
In column 3 I would like it to have a forumula that will allow
for "letter" to be displayed if there is a date in Col 1, "Follow
up" if there is a date in column 2 and "No Reply" if there is
no date in col 1 or 2. Can anyone help?


=IF(A1<"", "Letter", IF(B1<"", "Follow up", "No reply"))

Note that that does not test specifically for a date, but simply
whether or not the cells are empty. Do you truly need to
distinguish between a cell with a date versus a cell with a
different value or text?