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.