Create a spreadsheet that allows users of it to know how much to ask

[ffilia]

Hello! Hope someone with far more Excel knowledge could be able to help. I have attached a very rough (perhaps poor) attempt in trying to get what I would like.

I would like to create a spreadsheet that allows the user to pick a currency from a dropdown box (C1), which will in turn use the corresponding spot rate (C2), and input an amount to convert with a few conditions.

I have a spot rate (C2), an actual rate (C3) (which is 0.0075 less than the spot rate) and a bank rate (C4) (which is 0.03 less than the spot rate). I wish for the spreadsheet to be able to calculate an exchange rate which is half way between the "actual rate" and the "bank rate" so it would allow a tiny profit to be generated.

As a result, this should tell me a number to actually use to convert at the new rate generated (C9) from an amount put into cell C8

Could this be achievable?

[ben_hensel]

In C1:
Data Ribbon, Data Tools Tab, Data Validation Button to launch the popup menu
In default settings tab,
Validation Criteria, select "List" in the Allow dropdown
Source: =I2:I10 (the list of currencies; this could also be a named range).

In C2:

Please Login or Register  to view this content.

[ffilia]

In C1:
Data Ribbon, Data Tools Tab, Data Validation Button to launch the popup menu
In default settings tab,
Validation Criteria, select "List" in the Allow dropdown
Source: =I2:I10 (the list of currencies; this could also be a named range).

In C2:

Please Login or Register  to view this content.

Thank you so much! Now it works!