Conditional formula help

M

MaryFran

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!
 
S

Sandy Mann

Assuming that you are saying that the coverage date cell has other things in
it beside the target words then try:

=IF(ISNUMBER(LOOKUP(10,1/SEARCH({"present","days","months"},D2))),"Current","")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
F

FSt1

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

Regards
FSt1
 
S

Sandy Mann

You are very welcome. Thanks for taking the time to let us know that it
worked for you.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top