How to Calculate Fibonacci Numbers using Excel? 在EXCEL里也可以计算斐波那契数列

justyy (82)in #cn • 7 years ago (edited)

我们都知道斐波那契数列的定义如下：
We all know the Fibonacci sequence is defined as:

F(n) = F(n - 1) + F(n - 2)

and the terminating conditions are
其中

F(1) = 0, F(2) = 1

First few Fibonacci numbers are
前面几项的值为:

0, 1, 1, 2, 3, 5, 8, 13, 21 ...

If you code, that is easy, however, it is even easier just using Excel spreadsheet to calculate the Fibonacci numbers
写程序很简单，但是不用写程序仅用EXCEL也可以分分钟求出前几项的值。

Open Excel, 打开 Excel,
Put 0 at A1 在A1输入0
Put 1 at A2 在A2输入=A1+A2
Enter formula =A1+A2 at Cell A3 在A3输入公式 = A1+A2
Click and Drag A3 to fill the other cells in the same A:A column. 然后点击A3的右下角往下拉到底，立马就能计算斐波那契数列，很神奇有木有？

Excel autocomplete the formulas e.g. A4=A2+A3， A5=A3+A4 这是因为 EXCEL强大的公式自动填补，如：A4=A2+A3， A5=A3+A4以此类推.....

Originally published at https://steemit.com Thank you for reading my post, feel free to Follow, Upvote, Reply, ReSteem (repost) @justyy which motivates me to create more quality posts.

原文首发于 https://Steemit.com 首发。感谢阅读，如有可能，欢迎Follow, Upvote, Reply, ReSteem (repost) @justyy 激励我创作更多更好的内容。

// Later, it will be reposted to my blogs: justyy.com, helloacm.com and codingforspeed.com 稍后同步到我的中文博客和英文计算机博客。