Get instant live expert help on I need help with exchange rate formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
i need to calculate foreign exchange variance based on previous rate and current rate -
Solved by C. L. in 18 mins
I need to get the exchange rate to change the projected sales by -20 when the price of the cheese changes to +10 in relation to the exchange rate changing.
Solved by E. H. in 12 mins
I need help including xrates for exchange rate and creating a graph
Solved by B. C. in 19 mins
In B6 of the Currency Exchange worksheet, use a VLOOKUP function to look up the Country Traveling To, and return the country's Exchange Rate for $1.00 US from the table on the Currency Table worksheet.
Then, once you have that VLOOKUP function complete, multiply the VLOOKUP function x the US Dollars to Exchange (from the Currency Exchange worksheet). This will calculate the amount due based on each country’s exchange rate. Be sure to use absolute cell references where necessary.
Copy this formula to cell D6.
Change the monetary symbol accordingly for each country's conversion (using the Euro € 123 format for Germany).
Solved by I. F. in 17 mins
Hi! I need to link up sheet 1 and 2: 1 has salaries and 2: has %increase and exchange rate. I need a formula pls.
Solved by D. E. in 21 mins