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?

Enter this in I4 and copy down as needed:

=G$3*H4

The $ will keep the reference row from changing.

Biff

"Lisa" wrote in message
...
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?

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


On Mon, 7 Aug 2006 18:18:01 -0700, Lisa wrote:

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?