Forum Discussion

adminragnar's avatar
adminragnar
Copper Contributor
Sep 14, 2024

Excel formula for adding correct exchange rate to correct cell

Hello,

 

May I ask for help with this please.

 

I am running a web store, and in columns A-C (marked as 1) you can see parts of the sales report (see screenshot).

 

In column D, I wish to automatically insert the correct currency exchange rate for the Purchase Date (column B) and for the currency that was used to pay the order (column C).

 

Columns F-H and J-L (marked as 2 and 3) contains the exchange rates that should be used for Euro and USD.

 

So to get the correct currency exchange rates into the different rows of column D, the formula needs to:

-check that the order date (column B) is the same as the date in column F or J.

-check that the order currency (column C) is the same as the currency in column G or K.

 

For example:

-In cell D2, the correct currency exchange rate to be inserted is 10,35498 (from cell L10), because the order date (column B) is 2024-09-11 and the currency (column C) is USD.

 

Thank you!

 

Resources