Thread: enter a value for a cell according to a criteria in an other cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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.


Reply With QuoteReply With Quote