Using the AND and OR functions in the same formula
=IF(OR(LEFT(C1,1)="T",LEFT(C1,1)="G",AND(LEFT(A1,1 )="7",LEFT(C1,1)="A")),CONCATENATE(A1,B1,C1),"")
All on one line.......watch out for the posting word-wrap
Vaya con Dios,
Chuck, CABGx3
"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.
|