Home
Iterative Computing Fib Number using Excel
Tags:, ,

Iterative Computing Fib Number using Excel

June 28, 2012 No Comments excel

The Fibonacci Number is very well known, probably due to its recursive definition. [read this]

In Excel, you can easily list the Fib series in the cells using drag and auto-complete technique.

All you have to do is enter first two values of the Fib numbers i.e. 1, 1 in one colume e.g. A1, A2. The next thing is enter the formula =A1+A2 in the next row e.g. A3. The A3 value will be computed immediately which shows 2.

The next step is drag the A3 down to as many as you want… The formulations for new cells will automatically be filled by Excel with adjustments. e.g. =A2+A3, =A3+A4 …and so on.

Isn’t this easy? 🙂

excel Iterative Computing Fib Number using Excel excel

You may also like: 在EXCEL里也可以计算斐波那契数列

–EOF (The Ultimate Computing & Technology Blog) —

GD Star Rating
loading...
211 words
Last Post: A Recursive Full Permutation Algorithm in Python
Next Post: How to Display Your Email Address As Image?

The Permanent URL is: Iterative Computing Fib Number using Excel

Related posts:

  1. How to Implement Integer Square Root in C/C++? Question: Implement integer square root for int sqrt(int x) There are many ways to compute the...
  2. Group, Label and Functions in Windows Batch A group of commands in windows batch can be enclosed by brackets. The commands are...
  3. Teaching Kids Programming – Most Common SQL keywords (Select, Update, Insert, Delete) Teaching Kids Programming: Videos on Data Structures and Algorithms Here are a few SQL keywords...
  4. Passing Variables through different pages in PHP You often need to pass/keep variables from pages to pages when you design the website....
  5. Review: Lenovo ThinkCenter M900 Tower Station The new machine Lenovo ThinkCenter M900 Tower Station has just arrived! my current Lenovo Laptop...
  6. Simple Math Exercise – Computer V.S. Human I came across this simple question: A entry level math question for kids, A, B,...
  7. Better SQL Insert Syntax The SQL Insert statement is used when you want to insert new rows of data...
  8. Integration Tests Using PHPUnit to Ensure Your Website is Working with Static and Dynamic Contents You must want to make sure your website is configured properly to work with the...

Leave a Reply