我们都知道 [斐波那契数列](https://justyy.com/archives/1031) 的定义如下：
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](https://justyy.com/archives/1337)也可以分分钟求出前几项的值。

1. Open Excel, 打开 [Excel](https://justyy.com/archives/1905),
2. Put 0 at A1  在A1输入0
3. Put 1 at A2 在A2输入=A1+A2    
![](https://steemitimages.com/DQmdMcJxphj9djJPJoSSU9hp32fzTrEnkSuVh5dpM7XCMM2/image.png)
4. Enter formula =A1+A2 at Cell A3   在A3输入公式 = A1+A2
![](https://steemitimages.com/DQmcfmR8zPhYSfo9zBMCveAbeTFVTCTpnpthdK73zztwGmT/image.png)
5. Click and Drag A3 to fill the other cells in the same  A:A column.  然后点击A3的右下角往下拉到底，立马就能计算斐波那契数列，很神奇有木有？
![](https://steemitimages.com/DQmfH8RomEdkgAZ8QCwoCVB5kSraLuF4uA7PR32h1BS2GGU/image.png)
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](https://justyy.com), [helloacm.com](https://helloacm.com) and [codingforspeed.com](https://codingforspeed.com)  稍后同步到我的[中文博客](https://justyy.com)和英文[计算机](https://helloacm.com)[博客](https://codingforspeed.com)。
- [Iterative Computing Fib Number using Excel](https://helloacm.com/iterative-computing-fib-number-using-excel/)
- [在EXCEL里也可以计算斐波那契数列](https://justyy.com/archives/5220)

# 近期热贴
- [过去7天收益排行榜](https://steemit.com/stats/@justyy/daily-top-30-authors-in-cn-cn7-2017-09-01)
- [聂小倩 （1）| #5电影](https://steemit.com/cn/@justyy/1-or-5)
- [面经：Python 的 List 和 Dictionary 有啥区别？](https://steemit.com/cn/@justyy/interview-question-what-is-the-difference-between-list-and-dictionary-in-python-python-list-dictionary)
- [今天国足嬴了，我们来说说什么是SEO？流量怎么挣钱？](https://steemit.com/cn/@justyy/seo)
- [SteemIt 好友微信群排行榜 - （实时更新版）](https://steemit.com/cn/@justyy/steemit-daily-wechat-group-ranking-steemit)
- [SP小于500也可以通过程序来设置点赞百分比](https://steemit.com/cn/@justyy/voting-weight-for-sp-less-than-500-sp-500)
- [碧桂园海外(英国)招博士让我思考了人生规划, 碧桂园适不适合你?](https://steemit.com/cn/@justyy/3dyled)
- Ned 的代理SP是怎么被使用的 - Steemit 商业分析 [Part 1](https://steemit.com/cn/@justyy/ned-sp-steemit-part-1), [Part 2](https://steemit.com/cn/@justyy/ned-sp-steemit-part-2), [Part 3](https://steemit.com/cn/@justyy/ned-sp-steemit-part-3-sweetsssj-tumutanzi) and [Part 4](https://steemit.com/cn/@justyy/ned-sp-steemit-part-4)

# Recent Popular Posts
- [Daily Top 30 Authors Pending Payout in the Last 7 days ](https://steemit.com/stats/@dailystats/daily-top-30-authors-pending-payout-in-the-last-7-days-2017-08-31) 
- [Interview Question: What is the difference between List and Dictionary in Python?](https://steemit.com/cn/@justyy/interview-question-what-is-the-difference-between-list-and-dictionary-in-python-python-list-dictionary)
- [SteemIt Daily Wechat Group Ranking](https://steemit.com/cn/@justyy/steemit-daily-wechat-group-ranking-steemit)
- [Voting Weight for SP less than 500](https://steemit.com/cn/@justyy/voting-weight-for-sp-less-than-500-sp-500)
- [SteemSQL Tutorial: How to Get Authors Order By Potential Payout in Last 7 days?](https://steemit.com/cn/@justyy/steem-sql-7-cn)

https://justyy.com/gif/steemit.gif
Tags: #cn #cn-programming #programming #steemstem #excel