hey folks in this video I'm going to show you how to use the Google Finance function in Google Sheets to convert currencies first off we're going to look at the basic solution to get the rate and then we'll use that in a more Dynamic setup to collect the three digit country codes automatically and then lastly we'll do that all wrapped up in a final solution here where we can use drop down lists to find the country that we want to convert from and convert to to get our final rate at the end here so let's dive in and see how that's done foreign okay so first up let's just create the first one here we're going to type in Google Finance and we'll open up with double quotes we'll type in currency with a colon and then we just type in the currency you want to convert from and to so let's say euros and Great British pounds so we do it all together like that close the double quotes and parentheses and hit return and then we get our rate just like that and then in order to work that out as a final figure we could just multiply the amount to convert from by the rate to get our amount in the other currency but to make that a little bit more Dynamic we can use these fields here rather than typing it out manually like this and I'll show you how to do that so the same thing equals Google Finance type in currency and the colon and then we'll close the double quotes and then we use the Ampersand and we join that together with this value here with another Ampersand and this sign here and you can see here we're getting our rate and then we can close the parentheses what we're doing here is we're just concatenating all of this together to get the same result as we did have up here so that gives us our final rate and then you can see here we've got 15 euros and then what we do is we multiply the 15 euros by the rate to get that into in this case pounds and lastly with this solution here I'm collecting the countries from a separate list here where we've got a list of all the countries the country and the currency and then the actual code that we use here and so we can literally just choose a country from this list here and that we want to convert from and you can see that's Chinese running beat Yuan so that's the country code there and we want to convert that into pound sterling so this is 10 Yuan renimbi and so how do we get that in here so we can just do the same thing equals Google Finance double quotes currency and the colon followed by the closing the quotes and the same thing we did before with the Ampersand and now we use the starting rate here and the the final rate here and then we multiply that by the first value in this case Chinese running B and what we can do is we can just add an if an A so if there's a problem at the beginning here if you're trying to convert one currency into another for example then it wouldn't work so this would prevent any errors and there we go so 10 renimbi is one pound and nine Pence so this is a really useful setup I would encourage you to build something like this yourself where you show the countries in a list like this I've got a video on the drop down chips if you want to go and check that out I'll pop a link in the description box below for that and I'm doing a vlookup formula here to collect the currency and the code so that we can utilize that for this final Google Finance function so I hope you found that useful guys if you did make sure you give us a thumbs up and subscribe to the channel but that's all for today thanks for watching foreign [Music]