One way that seems to work.

=IF(AND(LEFT(A1,1)="7",OR(LEFT(C1,1)="A",LEFT(C1,1 )="T",LEFT(C1,1)="G")),CONCATENATE(A1,B1,C1))

"Jim Thomlinson" wrote in message
...
You can use And / Or in the same function but you need to be very careful
with your bracket and such. Try this...

=IF(AND(LEFT(A1,1)="7", OR(LEFT(C1,1)="A",
LEFT(C1,1)="T", LEFT(C1,1)="G")), A1 & B1 & C1, "")

--
HTH...

Jim Thomlinson


"Jan Buckley" wrote:

I need to create a formula that says IF LEFT(A1,1)="7" AND LEFT(C1,1)="A"
OR
LEFT(C1,1)="T" OR LEFT(C1,1)="G", THEN CONCATENATE(A1,B1,C1)

I don't know if I can use AND and OR in the same formula, or how to
string
it all together. Help, please. Thank you.