If or statements containing multiple calculation depending on cell values

[wh0]

Hi,
I have a workbook with multiple worksheets and table. I am trying to perform calculation depending on selected values in cell Column A. so in B1 I want the following to happen
if A1=ID 1 then do the following calculation C1*exp(-0.5/4)*(22-C1), or if A1=ID 2 then do this calculation D1*exp(-0.5/4)*(22-D1), or if A1= ID 3 then do this D1*exp(-0.5/4)*(22-D1), otherwise leave B1 blank.

	A	B	C	D	E
1	ID 1
2	ID 2
3	ID 3

 

[Fluff]

Hi & welcome to MrExcel.
Should ID 3 look at col E rather than D?

 

[Fluff]

Assuming the answer to my question is Yes, try

+Fluff 1.xlsm
	A	B	C	D	E
1
2	ID 1	105.8996	10
3	ID 2	75.01224		5
4	ID 3	35.29988			20
5	ID 4
Data

Cell Formulas
Range	Formula
B2:B5	B2	=LET(c,SWITCH(A2,"ID 1",C2,"ID 2",D2,"ID 3",E2,""),IFERROR(c*(22-c)*EXP(-0.5/4),""))