# Simple question regarding currency exchanger

Hello,

I have looked all over the place and still not found a solution to what to me seems like a rather simple problem.

So I have a calc document where I can see all my sales. The problem is that it is in EURO and I need it to be in SEK.
How do I easily convert all the EURO to SEK?

Keep in mind, I cannot use any built in programs but I have to use a formula. I have to use the specific currency exchange rate for every date In order to get the exact number.

I will exemplify below just to avoid any misunderstanding:

"Sale ABC - 100 EURO - 25 EURO Shipping - Total 125 EURO - Date - 2019-12-12

On date 2019-12-12 1 Euro was worth 10.10 SEK"

I need to very simply convert all EUROs on the date 2019-12-12 to SEK.
And then for a different date I suppose I have to do this again but with a different exchange rate etc.

Thank you very much.

Hello,

• Evaluate for a given Sale Date the related Exchange Rate (by using function `VLOOKUP()`)
• Use this evaluated exchange rate to calculate the SEK values (in columns `G` and `H`) from the given EUR values in columns `C` and `D`.