How do I convert a column from USD to GBP
 

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?

with your value in A1, in B1 enter:

=A1+(A1*.92)

format as Currency and select the GBP currency Symbol

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=383116

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.


"Lisa" wrote in message
...
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?