rosearangel23
New Member
- Joined
- May 23, 2018
- Messages
- 1
Hello!
I want to make a currency calculator in Excel but not quite sure how to do it.
Basically, I want 2 sheets. The first sheet is where I can calculate the currencies and the second sheet where the data is located.
So in the first sheet, I have a drop down for types of currencies (USD, BHD, CAD, THB, and so on) and when I choose any of the drop down, it will auto populate the denominations available for that currency and then I can put the number of bills that I have and it will calculate how much is the total amount.
I want to make a currency calculator in Excel but not quite sure how to do it.
Basically, I want 2 sheets. The first sheet is where I can calculate the currencies and the second sheet where the data is located.
So in the first sheet, I have a drop down for types of currencies (USD, BHD, CAD, THB, and so on) and when I choose any of the drop down, it will auto populate the denominations available for that currency and then I can put the number of bills that I have and it will calculate how much is the total amount.