Microsoft Excel Functions & Formulas

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.

4

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.

Formulas in Excel

5

1

Figure 1-4