How to make currency converter sheet in EXCEL ?
This is too easy to make a currency converter sheet in excel just follow these simple steps one by one
1:First make a list with name and Currency Rates in Excel like below
This is too easy to make a currency converter sheet in excel just follow these simple steps one by one
1:First make a list with name and Currency Rates in Excel like below
2:Now make this sketch
Step 3:now make a list with Data validation like below
4: Select List
5: now chose Source list and click Ok
6: now make this list 2 sides "From" & "To" like you can see in below sheet and apply this formula.
7: input this Function, it will auto pick amount from front of every line.
8:in Result cell add this formula.
if you face any problem feel free and write your comment in below box.......... keep visit for more new Office Tutorial.