IF Formula criteria .

  • Thread starter Thread starter Doug
  • Start date Start date
D

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
 
Hi Doug

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

Cheers
JulieD
 
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.
 
Hi Doug
try
=IF(AND(OR(ISNUMBER(FIND("A",A2)),ISNUMBER(FIND("B",A2))),OR(LEFT(D2,1)
="A",LEFT(D2,1)="B")),"delete","")
 
Back
Top