Need Help

[marycowan]

I am trying to figure out how to make this calculator so I can select a currency and it will give me the calculated price, quoted price, and transfer price in the selected currency. Right now it is doing everything in Canadian dollars. I am thinking of making a dropdown list to select currency but am not sure how to code the excel to get it to change to selected currency. Not sure this makes sense.

 

[Dave Patton]

You can use a table or include the data within the formula.

You can post a mini sheet with the forum's tool XL2BB. We would then know the layout of the sheet and
we would not have type the information.

T202107a.xlsm
	A	B	C	D	E	F
1	Cdn amount	17.1
2					USD	0.83
3	USD	14.19	14.19		EUR	0.679
4	EUR	11.61	11.61		GBP	0.584
5	GBP	9.99	9.99		CNY	5.288
6	CNY	90.42	90.42
2b

Cell Formulas
Range	Formula
B3:B6	B3	=ROUND($B$1*VLOOKUP(A3,E2:F5,2,0),2)
C3:C6	C3	=ROUND($B$1*VLOOKUP(A3,{"USD",0.83;"EUR",0.679;"GBP",0.584;"CNY",5.288},2,0),2)