![]() The third argument requires the column index number of the array for finding the desired cell value. In the second argument, we have used the MATCH function, and so the MATCH function will return the desired row index number according to the currency automatically. Remember, this array should also be absolute. The first argument is the array F4:G10 from which we would extract the values. For an E xact match, we have written 0 here. So, you need to absolutely refer with a dollar($) sign or press F4.Īnd, the last argument denotes the type of match. ![]() Remember, you must use an absolute array here. That’s why we have chosen the F4:F10 cell reference. 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 |