how to create a repeat formula using the same multiplier?

[Guest]

Is there a way to create a formula in Microsoft Excel 2003 that uses the same
multiplier over and over? For instance, I am creating a spreadsheet where
cell G3 is created by averaging a column of numbers. Then, I want to
multiply G3 by each number in another column (such as, G3*H4=I4, then
G3*H5=I5). Is there a way to do this?

 

[Biff]

Enter this in I4 and copy down as needed:

=G$3*H4

The $ will keep the reference row from changing.

Biff

 

[Gord Dibben]

Lisa

Enter your multiplier in G3

In I4 enter =$G$3*H4 Note the $ signs which lock G3.

Copy down Column H.


Gord Dibben MS Excel MVP