Applying percentage calculator to table

M

Manicjoe

Hi ............

Grateful of any help to change a table of figures in one currency to
another by
applying a percentage calculator, eg Pounds sterling to US Dollars by
mutiplying
all figures in all cells by 1.73.

I can create the formula to make the change, but can't seem to apply
it to the
figures in the individual cells.

Thanks for any help.

Joe
 
N

Niek Otten

In an empty cell, enter the number 1.73.
Edit>Copy
Select your table of figures.
Edit>Paste special, check Multiply
 

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

How to stop calc using un-rounded data 4
formula to subtract percentage from whole 2
creating a calculator 1
Changing cell references automatically 3
How do I change the cell format to currency without a formula? 1
Calculator Answer Doesn't Match Excel Answer 3
Is it easier to do math in excel, or just use a calculator? 5
Applying a percentage increase to dollar figures throughout a workbook 1

Top