USE A WILDCARD CHARACTER IN A FORMULA

  • Thread starter Thread starter No_1rebecca
  • Start date Start date
N

No_1rebecca

i have part #s that begin with "E" that will get a certain bonus, all the
rest get a different bonus. I cant get a wildcard to work in my formula
example:
if(A2="E*", 0,(B2*1)), even if A2 = EF1000 (which is a part #) the formula
returns false and multiplies B2 by 1 instead of returning a zero
 
=if(left(a2,1)="E", 0, b2)



No_1rebecca said:
i have part #s that begin with "E" that will get a certain bonus, all the
rest get a different bonus. I cant get a wildcard to work in my formula
example:
if(A2="E*", 0,(B2*1)), even if A2 = EF1000 (which is a part #) the formula
returns false and multiplies B2 by 1 instead of returning a zero
Click to expand...
 
Back
Top