I'm trying to make a cell have certain text in it if different text is in another cell.

[xpander]

If the word 'text' is in cell L151 then cell should contain "POSTED" else "Not POSTED"how can this be done in EXCEL? =IF(L151 Like 'text',"POSTED")???=IF(L151 Like 'text',"POSTED")???

 

[Logit]

=IF(L151 = "text", "POSTED","NOT POSTED")

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(ISNUMBER(SEARCH("text",L151)),"POSTED","Not POSTED")