Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


Download Practice Workbook

You can download the practice workbook from here.


4 Quick Tricks to Convert USD to CAD in Excel

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.

Read More: How to Convert USD to Euro in Excel (3 Useful Methods)


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.

Read More: How to Convert Dollar into Rupees in Excel (2 Easy Methods)


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.

Read More: Currency Conversion Using VLOOKUP in Excel (2 Suitable Examples)


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 Automate Currency Conversion in Excel (5 Easy Methods)


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.

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. Also, you can visit the ExcelDemy website for more articles like this. Lastly, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo