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!

Conditional formula help
 

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


Replace @mailinator.com with @tiscali.co.uk


"MaryFran" wrote in message
...
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!

Conditional formula help
 

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!

Conditional formula help
 

Sandy,

This worked perfectly! Thanks so much for your help!

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"MaryFran" wrote in message
...
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!

Conditional formula help
 

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


Replace @mailinator.com with @tiscali.co.uk


"MaryFran" wrote in message
...
Sandy,

This worked perfectly! Thanks so much for your help!

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"MaryFran" wrote in message
...
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!