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

How can I use the * wildcard in an array formula 4
VLOOKUP source values are a formula result. Getting #N/A 7
Sumproduct with Wildcard * 5
How to set a formula if the value is with #N/A 4
Using a Wildcard (*) in formula accessing sheets in workbook. 1
Generate Payment Due Date to exclude Weekends and Public Holiday 4
use wildcard charachter over left() 3
Redistribution of values after reaching maximum 4

Top