how to create a repeat formula using the same multiplier?
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?
|