USE A WILDCARD CHARACTER IN A FORMULA
 

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

USE A WILDCARD CHARACTER IN A FORMULA
 

Try this:

=IF(LEFT(A2)="E",0,B2)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"No_1rebecca" wrote in message
...
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

USE A WILDCARD CHARACTER IN A FORMULA
 

=if(left(a2,1)="E", 0, b2)



No_1rebecca wrote:

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

--

Dave Peterson

USE A WILDCARD CHARACTER IN A FORMULA
 

=(LEFT(A2)<"E")*B2


"No_1rebecca" wrote:

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