USE A WILDCARD CHARACTER IN A FORMULA

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same forumula returns both 0 & N/A 2
VLOOKUP source values are a formula result. Getting #N/A 7
search function using wildcard 3
How can I use the * wildcard in an array formula 4
use wildcard charachter over left() 3
Help needed for Excel formula using if, iserr, match and vlookup! 1
Referring to a cell by using another cell for the row number 6
Formula to Increment by Letter not Number 6

Top