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.
|