Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So if e.g. A(1)=5, and N goes from 1 to 6, I will get a sequence as follows

5,7,9,11,13,15
 
Enter the first 2 cells, ie in A1: 5, in A2: 7
Then select A1:A2, copy* down to A6,
and Excel will fill the series as required

*drag the fill handle at the bottom right corner of A2
 
daibach said:
So if e.g. A(1)=5, and N goes from 1 to 6, I will get a sequence as
follows

5,7,9,11,13,15
Click to expand...


One way:

In A1:5
In B1:2

In A2 the formula:
=A1+$B$1

Copy A2 down with the fill handle (the little square in
the lower right corner of the cell).

Test with new values in A1 and B1
 
Back
Top