Convert Currency - Formulas In Excel - Microsoft Excel Tutorials

4.  Convert currency

In a worksheet, currency has to be converted from dollars (column B) to euros (column C). The rate of exchange from dollars to euros is placed in cell C1; here we use 0.8021.

To convert currency:

1. In a worksheet, enter your own data or the data shown in Figure 1-4.
2. Select cells C4:C8.
3. Enter the following formula: =B4*$C$1.
4. Press <-Ctrl+Enter->.
5. From the Format menu, select Cells.
6. Select the Number tab and then select Currency from the Category list.

7. Choose € Euro.
8. Click OK.

Note: To convert euros back to dollars, use the following formula: =C4/$C$1.


Watch the Video Tutorial - https://www.youtube.com/watch?v=775Pp454ywA

Hope You Like This Tutorial - Give Comments