How to Convert Currency in Excel | Formula to Convert Currency in Excel
HTML-код
- Опубликовано: 8 сен 2024
- In this video, we’ll show you how to convert currency in Excel.
If you want to convert one currency value to another, you can use a formula that automatically updates all the results if the conversion rate changes.
Follow these steps to do it.
1) Open your Excel file with 3 columns «Value in dollar», «Exchange rate» and «Value in euro».
2) Then open Google.com and search «dollar to euro». Find out the current exchange rate between dollar and euro, then copy and paste it in a blank cell (B2).
3) Write the formula =A2*$B$2 in the cell C2 and press Enter.
4) Drag the fill handle over the range cell that you want to contain the formula.
There we go!
❓💬 What other tips do you want to know? Let us know in the comments below.
#HowTech #Excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here t.me/howtechtv
✅ Commercial questions info@howtech.tv
✅ Facebook / howtechtv
✅ Instagram / howtechprojects
✅ Twitter / howtechprojects
Is this a joke? I was looking for ways , in which excel can look for currency rate at regular interval from web and update the worksheet accordinglt
This is one of the best troll videos I have ever seen.
are you kidding me??? speechless
Thanks, but is it possible to set it to calculate forward AND backward like in online currency converters?
How will the exchange rate in my Excel sheet automatically updates when the rate in real life changes? There is no link in the Excel sheet that trigger that
Thank you
Super video, thanks
I did exactly the samer but it says VALUE!,is it becasue i had the dollar sign next to it
Thanks, but how dp I get rid of the dollar sign that forms at the start of the converted currency?
Are you kidding me ?! I want excel to look up conversion rates not put my own. Goal should be automation not increasing tasks.
This is dumb. Excel can look up the rate, real time, so it doesnt use your static value