Multiplying all cells: HELP!

M

Martin

I am doing a spreadsheet for a UK business, computing all
in pounds sterling. My US partner wants a version in dollars.

How can I multiply all cells by the exchange rate, 1.87?

M.
 
J

JulieD

Hi Martin

put 1.87 in a cell somewhere and copy it,
then select your whole spreadsheet (you might want to duplicate/back it up
first)
and choose edit / paste special
click the mulitply radio button and ok

Cheers
JulieD
 
G

gaftalik

Edit your rate in a cell (1,87) copy it then select the cells you wan
to multiply , and paste special , click multiply , voila tout !

gaftali
 
G

gaftalik

another way is to edit your rate 1,87 in a cell lets say C1 then i
another column edit this formula :
=B1*$C$1 (where B1 is your value in Sterling pound )
And then drag your formula down the needed range.

Gaftali
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL FORMULA: ALL CELLS 4
Global currency conversion 1
Counting text cells then multiplying by a value in another column 6
How to calculate total cost using fixed hourly rate from [h:mm:ss:]? 4
Currency Conversion 3
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
Assistance with Formula 3
Need Help Creating a Macro to Multiply Cells by a Constant Number 5

Top