View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default excel, i want to add 20 in increments to the number 101+20

One way:

Manually:

A1: 101
A2: 121

Select A1 & A2, drag the fill handle (the lower right corner) down as
far as required.

By Formula:

A1: 101
A2: =A1 + 20*(ROW()-ROW(A1))

copy down.

In article ,
"boatbuilder" wrote:

i want to be able to add 20 to 101+20 as an example, therefore the result in
the cell would be 101+40, then copy it so it would go on 101+60, 101+80 etc.