Thread: formula setup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default formula setup

One way is to type 17 in the first cell, 34 in the second cell, then select
the 2 cells and fill down as appropriate.
Another way is to put =17*ROWS($1:1) in the first cell and fill down.
--
David Biddulph

"Old Red One" wrote in message
...
Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68.
How to write formula?