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.

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.

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 an
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 looking
for.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=500731