IF Formula criteria .

[Doug]

A B C D
1 Number Name GROUP Code
2 A1234 J Blogg premiere AB1

Formula required;

If A2 contains,(or starts with), the letter A or B and if
the first character in cell D2 starts with the letter A
or B,return,"delete",otherwise if the criteria only in A2
is not met,(not A or B),leave blank.

Your help apprieciated.

Doug

 

[JulieD]

Hi Doug

=IF(AND(OR(LEFT(A2,1)="A",LEFT(A2,1)="B"),OR(LEFT(D2)="A",
LEFT(D2)="B")),"delete","")

Cheers
JulieD

 

[Andy B]

Doug

There is probably a sweeter way, but you can try this:

=IF(AND(OR(LEFT(A2,1)="A",LEFT(A2,1)="B"),LEFT(D2,1)="A",LEFT(D2,1)="A"),"de
lete","")

Andy.

 

[Frank Kabel]

Hi Doug
try
=IF(AND(OR(ISNUMBER(FIND("A",A2)),ISNUMBER(FIND("B",A2))),OR(LEFT(D2,1)
="A",LEFT(D2,1)="B")),"delete","")