Using If, Left and Or Functions

[dpietari]

Hello,

I'm trying to get a formula with multiple conditions to work and am having a hard time. Basically:
If A1 starts with "ABCD" OR "EFGH", put the value (say, $10) of B1 into cell C1. If A1 starts with anything else, put a zero in cell C1.
I've tried combining If, Left and Or but I must be doing something wrong.

Thanks in advance.

 

[JoeMo]

=if(or(left(a1,4)="abcd",left(a1,4)="efgh"),b1,0)

 

[DanteAmor]

Or this

=IF(OR(LEFT(A1,4)={"abcd","efgh"}),B1,0)

 

[Eric W]

Or even (if B1 is numeric):

=OR(LEFT(A1,4)={"abcd","efgh"})*B1

 

[dpietari]

Success! Thank you!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.