![]() So, we have to select the cells where the currencies locate. Now, the MATCH function only gives the index number of the value. We reference the C5 cell as the first argument as this is the cell carrying desired currency and this is the value that we have to look for in the dataset. You can convert currency using the VLOOKUP formula too. How to Convert CAD to USD in Excel (4 Easy Ways)ģ.How to Get Exchange Rate by Date in Excel (2 Suitable Methods).Convert Euro to USD in Excel (2 Handy Methods).Read More: How to Convert USD to CAD in Excel (4 Quick Tricks) Remember, the Asterisk sign (*) is used for multiplication in Excel. As the EUR exchan`ge rate is 0.94 in respect of the USD, so we write 0.94 in the second argument. Now, in the second argument, we have to set the value for the true return of the logical test. If the currency is EUR, true will be returned. Now, if the first logical test returns false, it will go to the second IF, and at the first argument, it will test if the desired currency is EUR. If our desired currency is USD, we have set our exchange rate as 1. The second argument requires the input of the value returned when the logical test is true. Writing =IF enables the IF function of Excel. Subsequently, reference the cell of the given USD amount and multiply it with the desired currency exchange rate cell reference.įor example, apply the following formula.You can convert currencies manually by extracting the exchange rates from the internet and multiplying the rates individually with the given amount to get the amount in your desired currency. Convert Currency with a Simple Excel Formula Here, I will show you 4 practical examples with 4 formulas to convert currencies in Excel.Īt first, make a dataset for the currencies and exchange rates in respect of USD.ġ. And, we have to convert these amounts into Euro(EUR), British pound sterling(GBP), Indian rupee(INR), Canadian dollar(CAD), and Japanese yen(JPY) currencies accordingly. Here, in our dataset, the USD currency amount is there. 4 Simple Examples to Convert Currency with Excel Formula
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |