Global currency conversion

J

Jon Gaster

I have a complex spreadsheet, about four linked worksheets all in US
dollars. I have been asked to produce the same thing in pounds
sterling. Is there any way that I can divide the value of all cells by
say 1.9 to give me the sterling value - I have created a new cell with
the correct exchange rate so I can change that at any time but I am not
sure how I can apply it to all cells.

Many thanks for any assistance
 
B

Bob Umlas

enter 1.9 in a cell, copy it, select all the cells you want to divide by it,
use Edit/Paste special, select Values AND Divide.
For an easier more permanent way, pick a cell to divide everything by, say
G1, and enter 1 in G1, then change all your formulas to be what they are
now, divided by G1. If you need to divide by 1.9, simply change G1 to 1.9
and everything will be divided by 1.9. Simple to change.
Bob Umlas
 
Top