Thread: Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"daibach" wrote:
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
Reply With QuoteReply With Quote