How do I convert a column from USD to GBP

[Guest]

I am trying to convert a column of USD figures in excel into GBP then I want
to add 92% - is there a formula I can use?

 

[swatsp0p]

with your value in A1, in B1 enter:

=A1+(A1*.92)

format as Currency and select the GBP currency Symbol

HTH

Bruce

 

[Stevie D]

Hi Lisa,

Image you have the exchange rage (i.e. the number of dollars in a pound) in
cell B2 and the column of dollar values starts in cell A5.

The formula you want is: =(A5/$B$1)*1.92

When you copy the formula down column A, the reference will be relative i.e.
it will change depending on which row you are in e.g. A5, A6, A7 - however
the $ signs in the reference to cell $B$1 mean this is an absolute reference
and therefore when you copy the formula down it will always refer to this
cell.

=(A5/$B$1)*1.92
=(A6/$B$1)*1.92
=(A7/$B$1)*1.92

Hope this helps.