Formula if cell contains certain letter?

[b34r]

Is there a formula in 2003 I could use that let's me perform a different equation if a cell contains a certain letter? eg:

"3400A"
"3400B"

Is there a way to use the IF function to say "If cell contains letter "B", multiply it by "reference cell", if not, just leave it. ?

 

[PhilthePlanner]

Sorry, my table didn't perform properly in the post above. Here are the results:

Input	Output
310A 310B 310C	0 1 2

<tbody>
</tbody>

Phil

 

[mellie79]

I'm no expert, but I think if you nest the Find function you could achieve that.

=IF(ISNUMBER(FIND("B",A1)),1,IF(ISNUMBER(FIND("C",A1)),2,0))

With a quick test it produced these results:

Input	Output
310A	0

<tbody>
</tbody>

Hope this helps,

Phil

Hi Phil,

I used your formula and it worked great. Do you know how you would set it up if you wanted to include lower case letters as well?

Thanks

Mel