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

Get FREE Advanced Excel Exercises with Solutions!

Converting currency is an essential operation. We can do that in Excel very efficiently. USD (US Dollar) and CAD (Canadian Dollar) are widely used currencies. In this article, I will show 4 quick tricks to convert USD to CAD in Excel. Also, I will show the way to convert CAD to USD.


How to Convert USD to CAD in Excel: 4 Quick Tricks

Converting USD to CAD can be done in various ways. We can use different functions of Excel to convert USD to CAD. In this section, I will show 4 quick methods to convert USD to CAD. To demonstrate the procedures, I am using a dataset that includes USD Amount, Convert to, CAD Amount and Exchange Rate of different Currencies.

how to convert usd to cad in excel


1. Use Simple Excel Formula for Converting USD to CAD

In this method, I will use simple multiplication formula from Excel to convert USD to CAD. let’s walk through the procedures.

  • First, select Cell D5 and write the following formula there.
=B5*$G$9
  • Then, press Enter.
  • Simultaneously, we will see the converted CAD in Cell D5.

Use Simple Excel Formula for Converting USD to CAD

In the formula,
  • We multiplied the value of Cell B5(USD) by the value of Cell G9 (Exchange Rate).
  • Further, use the Fill Handle to copy the formula to the cells below.

  • Finally, we converted all the USD Amount to CAD Amount.

2. Apply IF Function to Change USD to CAD in Excel

We can apply the IF function of Excel to change USD to CAD. I am showing the steps to do that in the following section.

  • First, select and write the following formula in Cell D5.
=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
  • Next, hit Enter.
  • Further, use the Fill Handle to copy the formula in the following cells.

Apply IF Function to Change USD to CAD in Excel

In the formula,

  • We used the IF function that checks the Convert to type, takes the Exchange Rate accordingly, and multiplies it with value in Cell B5 (USD Amount).
  • Finally, we will see all USD converted to CAD.

3. Insert VLOOKUP Function to Convert USD to CAD

The VLOOKUP function is an excellent choice to convert USD to CAD. I am showing below the stepwise procedures to convert USD to CAD.

  • First, select Cell D5 and write the following formula there.
=VLOOKUP(C5,$F$5:$G$10,2,FALSE)*B5
  • In addition, press Enter.
  • Simultaneously, we will see the converted CAD Amount in Cell D5.
  • Further, use the Fill Handle to copy the formula in the cells below.
  • Finally, we will see all the converted CAD Amount.

Insert VLOOKUP Function to Convert USD to CAD

In the formula,

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

4. Change USD to CAD Using INDEX & MATCH Functions

We can do the same task of converting USD to CAD by using the INDEX function and the MATCH function. Let’s walk through the procedures.

  • First, select Cell D5 and write the following formula there.
=INDEX($F$4:$G$10,MATCH(C5,$F$4:$F$10,0),2)*B5
  • Then, hit Enter.
  • Consecutively, we will see the converted CAD Amount in Cell D5.
  • Further, use the Fill Handle to copy the formula in the following cells.
  • Finally, we will see all the USD Amount converted into CAD Amount.

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 range of cells  $F$4:$F$10 and then the value is multiplied by 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 quite similar to the procedure of converting USD to CAD. we will use simple multiplication formula for the procedures. Follow the steps given below for converting CAD to USD.

  • First, select Cell D5 and write the following formula there.
=B5*$G$5
  • Next, press Enter.
  • As a result, we will see the converted USD Amount in Cell D5.
  • Now, use the Fill Handle to copy the formula in the cells below.
  • Finally, we will see all the CAD Amount converted into USD Amount.

Insert VLOOKUP Function to Convert USD to CAD

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.

Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Conversion of currencies is a quite common task in Excel. Here, I have shown 4 quick tricks to convert USD to CAD. I hope this article will help you to perform your tasks efficiently. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Lastly, if you have any suggestions or queries, feel free to ask in the comment section below.


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan Shimul
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo