IF Cell Value contains Value A or B enter True

[robocop1906]

I need a formula that basically looks in a cell and if that cell contains certain characters then enter true. Example

If Cell A1 contains Values "Data" Or "Load" then enter True (This formula would be in cell Column B1) if not enter False.

 

[fairwinds]

Try:

=OR(A1="Data",A1="Load")

 

[nisht]

write formula in cell b1

=OR(D14 = "data",D14 = "load")

ohh it is there..

 

[LTunnicliffe]

Try:

=OR(NOT(ISERROR(FIND("LOAD",UPPER(A2)))),NOT(ISERROR(FIND("DATA",UPPER(A2)))))

Cumbersome but it works.

 

[robocop1906]

The cell contains other data, not only load or Data. How do you say if cell value contains values?

 

[BAlGaInTl]

This works for me.

=IF(OR(A1="Data",A1="Load"),"True","False")

 

[BAlGaInTl]

The cell contains other data, not only load or Data. How do you say if cell value contains values?

If you want it to be blank if A1 has no value, then use

=IF(A1="","",IF(OR(A1="Data",A1="Load"),"True","False"))

 

[Pugster]

If you need to find "load" or "Data" within the string then use;

IF(OR(FIND("Load",A1,1)<0,FIND("Data",A1,1)<0),"Action if True", "Action if false"

This should work.

 

[LTunnicliffe]

Did you try my solution???

 

[Aladin Akyurek]

Book1
	A	B	C	D
1	DataloadedonM	TRUE
2	Baddata	TRUE
3	HeavyLoad	TRUE
4	Misdown	FALSE
5
Sheet1

B1:

=COUNT(SEARCH({"Data","Load"},A1))>0