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

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: 3543) 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: 1745) 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