View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Coolchick Coolchick is offline
external usenet poster
 
Posts: 1
Default formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!

in my spreadsheet when i fill down the formula i want it to use one cell and
mulitply it by the row.

How do i do this, please help its driving me mad!