finding text and performing a calculation
 

Is it possible to look for a string of text in a cell, then perform a
calculation?
Example:
A1 = Senior Thesis Research (this column also contains data like "Lab Thesis")
B1 = 10
C1 = 5

If the word "Thesis" is in A1, multiply B1*C1, if it's not, enter zero. The
formula I tried works, but when a cell in column A doesn't have the word
"Thesis" I get "#Value!" error.

The formula I tried is:
=IF(FIND("Thesis",A1)0,B1*C1,0)

Thanks in advance. Scott

finding text and performing a calculation
 

The formula I tried is:
=IF(FIND("Thesis",A1)0,B1*C1,0)

Try it like this:

=IF(COUNT(FIND("Thesis",A1)),B1*C1,0)

Or:

=IF(COUNTIF(A1,"*Thesis*"),B1*C1,0)

--
Biff
Microsoft Excel MVP


"scokaw" wrote in message
...
Is it possible to look for a string of text in a cell, then perform a
calculation?
Example:
A1 = Senior Thesis Research (this column also contains data like "Lab
Thesis")
B1 = 10
C1 = 5

If the word "Thesis" is in A1, multiply B1*C1, if it's not, enter zero.
The
formula I tried works, but when a cell in column A doesn't have the word
"Thesis" I get "#Value!" error.

The formula I tried is:
=IF(FIND("Thesis",A1)0,B1*C1,0)

Thanks in advance. Scott

finding text and performing a calculation
 

A few keystrokes shorter:

=COUNTIF(A1,"*thesis*")*B1*C1

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
The formula I tried is:
=IF(FIND("Thesis",A1)0,B1*C1,0)

Try it like this:

=IF(COUNT(FIND("Thesis",A1)),B1*C1,0)

Or:

=IF(COUNTIF(A1,"*Thesis*"),B1*C1,0)

--
Biff
Microsoft Excel MVP


"scokaw" wrote in message
...
Is it possible to look for a string of text in a cell, then perform a
calculation?
Example:
A1 = Senior Thesis Research (this column also contains data like "Lab
Thesis")
B1 = 10
C1 = 5

If the word "Thesis" is in A1, multiply B1*C1, if it's not, enter zero.
The
formula I tried works, but when a cell in column A doesn't have the word
"Thesis" I get "#Value!" error.

The formula I tried is:
=IF(FIND("Thesis",A1)0,B1*C1,0)

Thanks in advance. Scott