If Function formula

[Bush Kangaroo]

IF cell A1 contains the word "DAM" in any part of the cell then cell A
must equal "UNAVAILABLE"


the key here is that the cell needs to contain the word "DAM" and if i
does i need it to be identified in a seperate cell.

Any suggestions??

Many Thank

 

[Frank Kabel]

Hi
try
=IF(ISNUMBER(FIND("DAM",A1)),"Unavailable","")