FIND formula help needed
 

Excel 2000

The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE! always
appears.

Any ideas?

CaroleO

FIND formula help needed
 

=IF(ISNUMBER(FIND("Overall",B2)),"Y","N")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Carole O" wrote in message
...
Excel 2000

The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE! always
appears.

Any ideas?

CaroleO

FIND formula help needed
 

You can embed an ISERROR test within the IF:
=IF(ISERROR(FIND("Overall",B2)),"N","Y")

"Carole O" wrote:

Excel 2000

The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE! always
appears.

Any ideas?

CaroleO

FIND formula help needed
 

"Carole O" wrote in message
...
Excel 2000

The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE! always
appears.

Any ideas?

CaroleO

FIND("Overall",B2) returns a number (that is the position of "Overall" in
whatever text is in B2), not true/false. So what you need is:
=IF((ISNUMBER(FIND("Overall",B2))),"Y","N")

FIND formula help needed
 

You are using the wrong function for what you are trying to do. The FIND
function is to find a string within a string, not to search columns.

"Carole O" wrote:

Excel 2000

The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE! always
appears.

Any ideas?

CaroleO

FIND formula help needed
 

Thank you all for responding so quickly. bpeltzer's solution worked like a
charm!

CaroleO

"JLGWhiz" wrote:

You are using the wrong function for what you are trying to do. The FIND
function is to find a string within a string, not to search columns.

"Carole O" wrote:

Excel 2000

The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE! always
appears.

Any ideas?

CaroleO

FIND formula help needed
 

Where did she state that she searched columns?

--


Regards,


Peo Sjoblom


"JLGWhiz" wrote in message
...
You are using the wrong function for what you are trying to do. The FIND
function is to find a string within a string, not to search columns.

"Carole O" wrote:

Excel 2000

The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE!
always
appears.

Any ideas?

CaroleO