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