View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa Lisa is offline
external usenet poster
 
Posts: 328
Default 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?