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?