Consider a list of currency rates where the base is USD:
1 USD =
0.90390 EUR
0.74771 GBP
1.30101 CAD
how can I convert the base from USD to GBP, such that I end up with:
1 GBP =
1.33767 USD
1.20993 EUR
1.74146 CAD
What kind of formula do I need to apply to each rate to convert the base? Note: rates are taken from xe.com and the desired output example might not be exactly correct.
Writing it as an answer to close the question,
Divide by rate of the desired new base. Here it is GBP, so divide by 0.74771.