Google Sheets allows you to get live or real-time currency conversion with the help of Google Finance function.
Just adding the code below to a cell will do that for you.
In the function above, the currencies are hardcoded. That means it won’t change that easily. However, it can be changed to a dynamic function. So let’s make it dynamic or changeable.
Now, what we have to do is replace the currency codes with cells’ reference names, where we can keep currency codes accordingly as needed.
In the example below, C2 is referring to A2 and B2 inside the googlefinance function to make it changeable. Make sure you use an ampersand (&) in front of each cell name to make it functional.
You can learn more about Google Finance function here 👉🏼 GOOGLEFINANCE.