IF a cell contains specific text
Perhaps use this?
=IF(ISERR(FIND("Not mapped",G4)),"Something else","Disregard")
Christine wrote:
Is there a way to include in a formula a command that will check if a cell
contains a specific string of text? For example, if cell G4 contains "Not
mapped" (and more text), then "Disregard" will be indicated in cell C4 -
IF(G4 contains "Not mapped","Disregard","Something else")
|