View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MaryFran MaryFran is offline
external usenet poster
 
Posts: 2
Default Conditional formula help

Here's what I need to do: One column (D2) in my spreadsheet has the coverage
dates of periodicals . I need to come up with the formula that would insert
"Current" into a new column if the coverage date cell has any of the
following words: present, days, or months. If the coverage date does not
have any of those three words, I want a blank cell. Any help would be muchly
appreciated!