Formula to perform multiplication

  • Thread starter Thread starter Consuelo
  • Start date Start date
C

Consuelo

Here is what I have
A B
+------+------+
1 | 1.25 | |
+------+------+
2 | .90 | |
+------+------+


I want the value of each row in column A to be multiplied
by 5% & have the result displayed in the corresponding row
in column B. I can do this with each individual row but
there are over 200 rows. How can I create a formula that
will apply that formula to each row individually
 
Hi Consuelo!

in B1 type:

=A1*5%

Now copy down parallel to column A and you'll find that the reference
always changes to refer to the cell to the left of where it is copied
to.

A fast way of copying down is to point to the bottom right corner of
B1 and double click the + grab handle.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top