# How to Convert USD to CAD in Excel (4 Quick Tricks)

In this article, we will present 4 quick tricks to convert USD to CAD in Excel (and how to convert CAD to USD). We’ll use the following dataset to demonstrate our methods.

### Method 1 – Using a Simple Formula for Converting USD to CAD

In this method, we will use a simple multiplication formula to convert USD to CAD. We’ve assumed a number of exchange rates between USD and various other currencies including CAD in the range F5:G10.

Steps:

• Select Cell D5 and enter the following formula:
`=B5*\$G\$9`
• Press Enter.

The amount in CAD is returned in Cell D5.

In the formula, we simply multiplied the value of Cell B5(USD) by the value of Cell G9 (the USD/CAD Exchange Rate).

• Use the Fill Handle to copy the formula to the cells below.

All the values in USD Amount are converted to CAD in CAD Amount.

### Method 2 – Using the IF Function to Convert USD to CAD in Excel

We can also apply the IF function to change USD to CAD.

Steps:

• In Cell D5, enter the following formula:
`=IF(C5="USD",1,IF(C5="EUR",1,IF(C5="GBP",0.88,IF(C5="INR",81.84,IF(C5="CAD",1.35,IF(C5="JPY",146.36))))))*B5`
• Press Enter.
• Use the Fill Handle to copy the formula to the cells below.

In the formula, the IF function checks the Convert to currency type, and fetches the corresponding Exchange Rate, which is then multiplied by the value in Cell B5 (the USD Amount).

• All the USD values are converted to CAD.

### Method 3 – Using the VLOOKUP Function to Convert USD to CAD

The VLOOKUP function is another efficient approach.

Steps:

• In Cell D5, enter the following formula:
`=VLOOKUP(C5,\$F\$5:\$G\$10,2,FALSE)*B5`
• Press Enter.

The converted CAD Amount is returned in Cell D5.

• Use the Fill Handle to copy the formula to the cells below.

We have all the converted CAD Amount values.

In the formula,

• The VLOOKUP function searches for the exact value of Cell C5 in the range \$F\$5:\$G\$10 and returns the corresponding Exchange Rate.
• Then the Exchange Rate is multiplied by the value of Cell B5 (USD Amount) to get the corresponding CAD Amount.

### Method 4 – Using the INDEX & MATCH Functions to Change USD to CAD

We can do the same task as the last method using the INDEX function and the MATCH function together.

Steps:

• In Cell D5, enter the following formula:
`=INDEX(\$F\$4:\$G\$10,MATCH(C5,\$F\$4:\$F\$10,0),2)*B5`
• Press Enter.

The converted CAD Amount is returned in Cell D5.

• Use the Fill Handle to copy the formula to the cells below.

All the USD Amount values are converted into CAD Amount values.

In the formula,

• The MATCH function finds the exact value of Cell C5 in the range of cells \$F\$4:\$F\$10.
• The INDEX function takes the corresponding Exchange Rate from the range \$F\$4:\$F\$10, and then the value is multiplied by the value of Cell B5 to get the CAD Amount.

Read More: How to Convert Euro to USD in Excel

## How to Convert CAD to USD in Excel

Converting CAD to USD is very similar to the procedure of converting USD to CAD. We will use a simple multiplication formula.

Steps:

• In Cell D5, enter the following formula:
`=B5*\$G\$5`
• Press Enter.

The converted USD Amount is returned in Cell D5.

• Use the Fill Handle to copy the formula to the cells below.

All the CAD Amount values are converted into USD Amount values.

In the formula, we simply multiplied the value of Cell B5 (CAD Amount) by the value of Cell G5 (Exchange Rate) to get the converted USD Amount.

## << Go Back to Currency Conversion in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF