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

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

Method 1 – Currency Conversion Applying Division Formula


  • Add a new column on the right side to convert the INR into USD.

Add new column for converted value in Excel

  • Add new rows in the dataset that explain the conversion rate of INR to USD.

  • Go to Cell D5.
  • Put the following formula:

Apply division operation to convert currency from INR to USD

  • Press the Enter button and drag the Fill Handle icon to fill other cells.

Method 2 – Find INR and Convert to USD Using IF Function

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

New dataset with different currency in Excel


  • Insert the following formula 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.

Method 3 – Find INR and Convert to USD Using VLOOKUP Function

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.


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

  • Apply this formula to Cell G5.

Use VLOOKUP formula to find and convert INR to USD

This formula will find out the product with a price in INR.

  • Press the Enter button.

  • Apply this function to Cell G6:

  • Press the Enter button.

Method 4 – Combine MATCH & INDEX Functions


  • Move to Cell G5.
  • Insert the following formula to that cell:

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

  • Press the Enter button.

  • Insert a formula combining the MATCH and INDEX functions on Cell G6:

  • Press the Enter button for the converted currency.

Download Practice Workbook

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

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

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF