Multiplication formulas....

  • Thread starter Thread starter John84
  • Start date Start date
J

John84

Hello,

A 2 part question here. Im completely new to excel so I apologize for
my lack of terminology....

1) Is it possible to multiply all the numbers in a column by a single
fixed number? For example, the column is a list of prices in US
currency but, I would like to convert them all to Canadian currency.
Can I do this without having to manually do it to each cell? Also, can
I have the answer come up in a different column?

2) Is there a way to multiply 1 set of numbers by numbers in a seperate
column. To continue with the previous example, can the numbers in the
*'prices'* column be multiplied by the numbers in a *'number of
copies'* column?

Once again I apologize for my lack of correct terms. Any help would be
appreciated.
 
You would need to do it for each row

if your prices are in column a rows 2 to 10
in b1 is your mulpy number

in c2 type in =a2*$b$1
press enter

run mouse pointer over bottom right corner of c2 until mouse pointe
becomes a +

hold down left mouse button and drag downwards. this will copy th
formula down couln c changing the row number for coulm a. Because o
the $ used to refer to b1 the b1 will not change.

c10 should end up with the formula =a10*$b$1

I hope this helps yo
 
hi there John,

for your first question, i believe it may be easier if you find a
empty cell, type in your 'single fixed number', copy it. now selec
all numbers you wish to multiply by that 'fixed number'. right clic
selection -> paste special -> multiply. if you want only static value
(first clear your 'fixed number' if desired) copy newly acquire
selection, copy/paste special -> values.

ht
 
Back
Top