Multiply ifs

[Giancar]

Hi everyone,

I was checking previous posts but I am not able to amend the formula in the way I wished.
So I have following table

1st week	1000
2nd week	2000
3rd week	5000

<tbody>
</tbody>

In C1 I need a formula that multiply B1*0.5 if A1is "1st week", if A1 is 2nd week multiply B1*0.35 and if A1 is "3rd week", multiply B1*0.15

Thank you in advance

 

[Weazel]

maybe...

=B2*CHOOSE(MATCH(A2,{"1st Week","2nd Week","3rd Week"},0),0.5,0.35,0.15)

 

[shg]

Assuming col A will always contain one of those values,

	A​	B​	C​	D​
1​	1st week	1000​	500​	C1: =B1*LOOKUP(A1, {"1st week","2nd week","3rd week"}, {0.5,0.35,0.15})
2​	2nd week	2000​	700​
3​	3rd week	5000​	750​

EDIT: I prefer Weazel's

 

[Giancar]

It is not working

 

[Giancar]

Well, my bad, both are working, but I have a problem when I drag down.
If I add the formula on specific cells is working, but if i Drag down it is not. What am I doing wrong?
Thx