Formula needed for a cell

[hsandeep]

I have 2 cells as below:
Sheet1

	B	C
DS

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #ffff00"] [/TD]

</tbody>

I want:
C2=100 if B2 contains either of "B" or "C" or "Q" or "R"
C2=200 if B2 contains either of "D" or "S"
ELSE C2=300

FORMULA REQUIRED FOR C2?
Thanks in adv.

 

[clabulis]

Give this a try:

=IF(COUNT(FIND({"B","C","Q","R"},B2))>0,100,IF(COUNT(FIND({"D","S"},B2))>0,200,300))

 

[hsandeep]

Give this a try:

=IF(COUNT(FIND({"B","C","Q","R"},B2))>0,100,IF(COUNT(FIND({"D","S"},B2))>0,200,300))

Can it be expanded to...
C2=100 if B2 contains either of "B" or "Q"
C2=200 if B2 contains either of "C" or "R"
C2=300 if B2 contains either of "D" or "S"
ELSE C2=400

 

[clabulis]

Will there ever be a situation in which B2 contains a letter from 2 different categories (ex: "B" and "D"). If so, what should the result in C2 be?

 

[hsandeep]

will there ever be a situation in which b2 contains a letter from 2 different categories (ex: "b" and "d") no it won't be. If so, what should the result in c2 be?

no it won't be

 

[clabulis]

This should work:

=100*IFERROR(ROUNDUP(MATCH(10^9,FIND({"B","Q","C","R","D","S"},B2),1)/2,),4)