Simple function question

[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.

 

[Robert Rosenberg]

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.

 

[Guest]

-----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

Thank you so much, i spent about three hours trying to use
help to do that simple thing, i really appreciate the help.