Simple function question

  • Thread starter Thread starter Bob Sampson
  • Start date Start date
B

Bob Sampson

i am trying to do a shortcut where i drag the formula down
the column. in the A column i have my percents (10,20,30,
ect), in c1 i have 200, in order to have the values in the
b column use a1,a2,a3,a4 multiplied by only c1, how do i
do that without having to do them one at a time. i want
to be able to just drag it striaght down column b and have
it do the formula (a1,a2,a3,a4,a5,a6..so on)*c1. or if
this makes more sense- in b1 i want a1*c1, in b2 i want
a2*c1, in b3 i want a3*c1. i want the c1 to be the
constant used for all of the equations. thank you so much
for your time. i hope this is meerley a simple thing.
 
Use the following formula and copy it down the B column:

=A1*$C$1

The dollar signs in front of the column letter tells Excel not to change it
when copied. The dollar signs in front of the row number tells Excel not to
change it when copied.
 
-----Original Message-----
Use the following formula and copy it down the B column:

=A1*$C$1

The dollar signs in front of the column letter tells Excel not to change it
when copied. The dollar signs in front of the row number tells Excel not to
change it when copied.

--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
Click to expand...
Thank you so much, i spent about three hours trying to use
help to do that simple thing, i really appreciate the help.
 
Back
Top