How to Convert Currency in Excel

In this Excel tutorial, you will learn how to convert currency in Excel.

Filling out currency data

For you to create a currency converter, you first needs data like this:

conversion usd

1. Layout the data you want to convert

layout data

2. Mark the data you want to convert, add one empty column, and then press CTRL + T, just press ok.

add empty column

Inserting currency conversion formula

3. Click inside the table (1), and type =(click on the cell with a currency you want to convert)*VLOOKUP([@currencies],$A$2:$B$3,2,False) (2), and press enter.

click inside column

Note: It is crucial that you add the $ before and after the column before righting the cell numbers in the range. This step will automatically calculate the rest.

4. Write Euro between total and 53293.

write euro

5. Change column2 to Euro

change column to euro

6. Choose all the cells in Euro column (1), right click on it, and choose Format Cells (2).

format cells

7. Choose Currency (1), choose Euro (2), and press ok (3).

currency format cell

Note: Repeat this step on the USD column, but choose the dollar sign this time In conclusion, the best way to create currency converter is to first get the rate for all the currencies you want to convert. These steps laid above will then help you use those rate to convert.

We have created a currency converter that look like this:

currency converter ready

Here you can download free Currency Converter.

See also  How to Cut ✂️ Text in Excel