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.