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

I have 3 columns. I need to put a date into either column 1 or column 2.
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?

Thanks