If cell contains text "A" or "B" then adjacent cell should give value "50" if it contains "A" or "60" if it contains "B"

[martacar]

Hey everyone,
I could really use your help.
I would like that column B automatically gives me either 50 or 60, depending if column A contains Q1 or Q2.
If it contains Q1 i would want them to give me as a result 1, if it contains Q2 i would like as a result 0,75, Q3 i would like to receive as a result 0,5 and Q4 i would like as a result 0,25.
Can anyone help! thanks a lot.

A	B
Prorrata Q1	1
Prorrata Q2	0,75
Prorrata Q3	0,5
Prorrata Q4	0,25

<tbody>
</tbody>

 

[Indystick]

Your question is a bit confusing because the 3rd sentence seems to me to run counter to the fourth sentence. I went with what you have laid out in the table / fourth sentence:

=IF(ISNUMBER(SEARCH("Q1",A1)),"1",IF(ISNUMBER(SEARCH("Q2",A1)),"0, 75",IF(ISNUMBER(SEARCH("Q3",A1)),"0, 5","0,25")))

 

[Yongle]

This is a simple formula and works with your simple sample data
BEWARE - it is only looking at the last character in the cell

=CHOOSE(RIGHT(A2,1),1,0.75,0.5,0.25)