enter a value for a cell according to a criteria in an other cell
 

I am a newbie and I want to do the following. For every cell in column
A with any "5"character in the cell, to have the value "YES'' in
Column D on the same row. You help is much apreciated. Thanks in
advance.

enter a value for a cell according to a criteria in an other cell
 

In d1 and drag down

=IF(ISERROR(FIND("5",A1,1)),"","YES")

Mike

"mango" wrote:

I am a newbie and I want to do the following. For every cell in column
A with any "5"character in the cell, to have the value "YES'' in
Column D on the same row. You help is much apreciated. Thanks in
advance.

enter a value for a cell according to a criteria in an other cell
 

On 13 Jun, 21:49, Mike H wrote:
In d1 and drag down

=IF(ISERROR(FIND("5",A1,1)),"","YES")

Mike



"mango" wrote:
I am a newbie and I want to do the following. For every cell in column
A with any "5"character in the cell, to have the value "YES'' in
Column D on the same row. You help is much apreciated. Thanks in
advance.- Hide quoted text -

- Show quoted text -

thanks Mike,

How about if I only am looking for a character in the cell
value?......
''......
;