Exel

Hi Kiran

Thank you for your question. There might be a number of ways to make this work. One option would be to multiply the UK prices by the US rate to work out their dollar value. If Cell A1 has the UK figure, B1 could contain the US rate (dollars per pound) in C1 we could put a formula

=A1*B1

The result would be the US rate for the UK price

If you have lots of prices you may pefer to do away with column B as every cell will be identical (the US conversion rate) and instead store the US rate in one cell, e.g. D1

Now the formula in C1 to convert the UK rate to US would be =A1*D1

Finally we need to deal with copying the formula for all the products in the price list. To do this we must tell Excel to always refer to the rate in D1 wherever the formula is used.

The $ symbol is added to the formula, within the cell reference, to specify whether the row or column must remain unchanged when the formula is copied. When used like this the symbol no longer refers to currency.

In this case we might modify the formula as follows

=A1*$D$1

Now the formula could be copied down (or across) your sheet and it would always incorporate the reference to D1.

If the US rate changes you can modify the contents of cell D1 and any formula using that value will update to incorporate the new rate.

I hope this helps - do let us know if you have any further questions.

Kind regards,

Andrew