hi
try this....
=IF(OR(D2="present",D2="days",D2="months"),"curren t","")
copy down?

Regards
FSt1

"MaryFran" wrote:

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!