hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

Try something like this:

With
A1: (a value that may contain the word "cow")

Then
B1: =IF(COUNTIF(A1,"*COW*"),formula if TRUE, formula if FALSE)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

yeah that is perfect, thanks

"Ron Coderre" wrote:

Try something like this:

With
A1: (a value that may contain the word "cow")

Then
B1: =IF(COUNTIF(A1,"*COW*"),formula if TRUE, formula if FALSE)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

=ISNUMBER(FIND("cow",A1))
rok wrote:
yeah that is perfect, thanks

"Ron Coderre" wrote:

Try something like this:

With
A1: (a value that may contain the word "cow")

Then
B1: =IF(COUNTIF(A1,"*COW*"),formula if TRUE, formula if FALSE)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks