Ask Your Question
0

Continue a function (arithmetic sequence) down a column [closed]

asked 2014-02-10 20:04:48 +0200

heartpink gravatar image

updated 2014-02-11 04:13:51 +0200

oweng gravatar image

Hi, I want a column which starts with the first value on A1 e.g. 3. The following data down the column should be:

A1*1
A1*2
A1*3
A1*4
.... and so on.

When I select three terms and drag the black box, bottom right, down. It continues:

A3*1
A3*2
A3*3
A6*1
A6*2
.... etc.

Please help.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 09:26:40.260917

Comments

@oweng: Thanks for clarifying what @heartpick wanted to do. Now I understand his intention and question.

ROSt52 gravatar imageROSt52 ( 2014-02-11 05:34:08 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2014-02-11 04:18:10 +0200

oweng gravatar image

In cell A1 enter the initial base (e.g., 3). In cell A2 enter the formula =A1+A$1. Click on cell A2 and drag down. This will continue to add the value in cell A1 (using an absolute reference to row 1 i.e., $1) to the value in the prior cell (i.e., A3 for cell A4, etc.)

edit flag offensive delete link more
1

answered 2014-02-11 04:11:49 +0200

ROSt52 gravatar image

@heartpick - your cell content is not really clear to me but maybe the screenshot helps you.

image description

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-02-10 20:04:48 +0200

Seen: 557 times

Last updated: Feb 11 '14