IF Cell Value contains Value A or B enter True

Thanks:  0
Likes:  0

# Thread: IF Cell Value contains Value A or B enter True

1. ## IF Cell Value contains Value A or B enter True

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.

Try:

3. ## Re: IF Cell Value contains Value A or B enter True

write formula in cell b1

ohh it is there..

4. Try:

Cumbersome but it works.

5. ## Re: IF Cell Value contains Value A or B enter True

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

6. ## Re: IF Cell Value contains Value A or B enter True

This works for me.

7. ## Re: IF Cell Value contains Value A or B enter True

Originally Posted by robocop1906
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

8. ## Re: IF Cell Value contains Value A or B enter True

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.

9. Did you try my solution???

10. ## Re: IF Cell Value contains Value A or B enter True

******** ******************** ************************************************************************>
 Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows NT 4
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 B1B2B3B4 =

A
B
C
D
1
2
3
4
M is downFALSE
5
 Sheet1

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

B1:

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•