How to Convert INR to USD in Excel (4 Methods)

Get FREE Advanced Excel Exercises with Solutions!

Conversion of currency is very common now. People visit from one country to another, they need to convert their currency. In case of buying any product from the foreign, that time we also need to convert currency. In Excel, we can convert the currency of a product in multiple ways. But in this article, we will show only how to convert INR to USD in Excel with proper illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Methods to Convert INR to USD in Excel

We will show some simple methods to convert from INR to USD based on different Excel functions and multiplication. Have a look at the below methods.

We have the following dataset, which contains the price of some products in INR. We will convert them into USD.


1. Currency Conversion Applying Division Formula

In this method, we will apply a simple division operation to convert INR to USD in Excel.

📌 Steps:

  • We have added a new column on the right side to convert the INR into USD.

Add new column for converted value in Excel

  • We add new rows in the dataset that explains the conversion rate of INR to USD.

  • Go to Cell D5.
  • Put the following formula based on division operation.
=C5/$C$13

Apply division operation to convert currency from INR to USD

We divide INR with a factor to convert into USD.

  • Press the Enter button and drag the Fill Handle icon.

Finally, we converted INR into USD successfully.

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


2. Find INR and Convert to USD Using IF Function

In this method, we will find INR from a given list of currencies and then convert that into USD.

📌 Steps:

  • This is the dataset from which we will find INR values and then convert them to USD.

New dataset with different currency in Excel

  • Now, create a formula based on the IF function and insert it into Cell E5.
  =IF($D5=$C$12,$C5/$C$13,"Not in INR")

Convert from INR to USD applying IF function based formula

  • Press the Enter button.

Get result after conversion from INR to USD

We converted the INR values and when there is no value of INR indicated as Not in INR.

Read More: Convert Euro to USD in Excel (2 Handy Methods)


3. Find INR and Convert to USD Using VLOOKUP Function

In this method, we will use the VLOOKUP function to find out the products whose price is INR and then convert that into USD.

The VLOOKUP function looks for a value in the leftmost column of a table and then returns a value in the same row of a column you specify. By default, the table must be sorted in ascending order.

📌 Steps:

  • We add new cells in the dataset for the name of the product and price in USD.

  • We apply a formula to Cell G5.
=VLOOKUP($C$12,$B$5:$D$9,2,FALSE) 

Use VLOOKUP formula to find and convert INR to USD

This formula will find out the product, which is given in INR.

  • Press the Enter button.

We can see the name of the product is showing.

  • Now, we will apply another VLOOKUP function on Cell G6.
  =INDEX($D$5:$D$9,MATCH($C$12,$B$5:$B$9,0))/C13

  • Again, press the Enter button.

Here, we converted the INR into USD. This is our desired result, which is converted from INR to USD.

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


4. Combine MATCH & INDEX Functions

The working process of this method is similar to VLOOKUP. First, we will find out the product with currency in INR and then, convert the currency into USD.

The MATCH function returns the relative position of an item in an array that matches a specified value in a specified order.

The INDEX function returns a value or reference of the cell that is the intersection of a particular row and column, in a given range.

📌 Steps:

  • Move to Cell G5.
  • Then, insert the following formula on that cell.
  =INDEX($C$5:$C$9,MATCH($C$12,$B$5:$B$9,0))

Combination of MATCH & INDEX functions to find and convert INR to USD

  • After that, press the Enter button.

We get the name of the product in currency INR.

  • Again, we insert a formula combining the MATCH and INDEX functions on Cell G6.
  =INDEX($D$5:$D$9,MATCH($G$5,$C$5:$C$9,0))/C13 

  • Finally, press the Enter button for the converted currency.

We get the price of the T-shirt in USD after converting from INR.


Conclusion

In this article, we described how to convert currency from INR to USD in Excel. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.


Related Article

Alok Paul
Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo