View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phippsy Phippsy is offline
external usenet poster
 
Posts: 28
Default consecutive numbers

I want to have a column which has a formula which multiplies an absolute cell
by a number which increases incrementally.
=1*$A$4
=2*$A$4
etc. up to about 100. How can I enter the consecutive number into the
formula so I can replicate it? I don't want an extra column with the numbers
1-100!
Thanks