Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.newusers




Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2
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 
#2




Answer: Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2
Creating a Recurrence Formula in Excel
You can use this technique to create other types of recurrence formulas as well.
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.newusers




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 
#4
Posted to microsoft.public.excel.newusers




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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do i create a countif formula in excel?  Excel Worksheet Functions  
Can I create an IF formula for single cell w/ dif. text in Excel?  Excel Discussion (Misc queries)  
Can I create a formula in Excel that evaluates form information?  Excel Worksheet Functions  
Create an ifthen formula in Excel to limit column total?  Excel Discussion (Misc queries)  
How do I create a formula in Excel that will countif or sumif bef.  Excel Worksheet Functions 