View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Leo Heuser Leo Heuser is offline
external usenet poster
 
Posts: 266
Default Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2

"daibach" skrev i en meddelelse
...
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



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


--
Best regards
Leo Heuser

Followup to newsgroup only please.