All cells in wksht to be multiplied by B3 (canadian conversion rate)

  • Thread starter Thread starter Shelley
  • Start date Start date
S

Shelley

I am trying to create a chart where every dollar amount
has to be converted into Canadian dollars, therefore,
every cell needs to be muliplied by the number in cell
B3. I would greatly appreciate some feedback, this is so
frustrating to me that I have not been able to figure
this out and I refuse to type the formula in each and
every cell manually :)

Desperately seeking answers.
 
hi
if this is a onetime operation try the following:
- select cell B3 and copy it
- select your target cells
- goto 'Edit - Paste Special' and choose the action 'Multiply'
 
Frank...I can't thank you enough! This works
beautifully, I knew it wasn't a complex function to
complete; trying to find the exact answer to my question
in the help text was brain damage! Thanks so much!!!

Shelley
 
If you don't want to lose the underlying values in your cells, then in any other
cell type =$B$3, then copy that cell, select all your data and do Edit / Paste
Special / Multiply. Each cell's value will now be =Value*($B$3) and so you will
ha the underlying values still, but the ability to change the rate at will
simply by amending B3.
 
Back
Top