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...