Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

GBP/USD currency rate and inverse

0

Hello and thank you for any help...

I want to show an amount of $ in a fixed cell

The show an auto day date in col 1 and increase this each day

Then show an automatic currency rate for the USD/GBP pair eg 0.77450, calculate and show the £ amount by the rate.

Then show the Inverse rate for GBP/USD pair eg 1.29450, thus:

Auto day date       USD rate     £ Amount     GBP rate    £Amount x rate   %change

                                                                                                                   (from day before)

Many thanks

Tony

excelformulas-functions
MS Office Version: 13
posted by: alfiepanda on Wed Nov 20, 2019 at 7:14 am
Answer
Discuss

Discussion

Edit your post to include a workbook with at least two rows of data calculated manually just the way you want.
Variatus (rep: 4889) Nov 20, '19 at 8:22 pm
I'm assuming you want to get the exchange rate into Excel automatically each day as well. Regardless, at least try to make the spreadsheet and then post it here and ask for help where you need it)
don (rep: 1989) Nov 26, '19 at 4:41 am
Send me file for ur solution
beepetark Nov 28, '19 at 7:26 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login