Not enough specific info. Maybe something like this:

=IF(OR(A1={"a","b","c","f"}),B1,0)

--
Biff
Microsoft Excel MVP


"s bruce" <s wrote in message
...
How can I write a formula that in effect goes =IF(cell# contains character
a,b,c,f) then insert contents of cell# here, if not then 0)