excel, i want to add 20 in increments to the number 101+20

B

boatbuilder

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.
 
J

JE McGimpsey

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.
 
M

mphell0

This is definitely not the best way to do this but it works:

In the cell at the top of the column enter '0000000 (with a
apostrophe)

In the next cell down put this formula:

="101+"&(20+MID(C7,5,3))

And copy down. I think this will give you the result you are lookin
for
 
Top