Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelHow to Create Fibonacci Sequence in Microsoft Excel ?

# How to Create Fibonacci Sequence in Microsoft Excel ?

This article will explain in simple steps on how to create a fibonacci sequence in Microsoft Excel.

A finonacci series in excel is a series of numbers by adding the previous two numbers. For example , below is a series of numbers in the Fibonacci sequence

`0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, â€¦`

In the above example , the next number in the sequence is applied by adding the previous two numbers before it. For example , 13 is calculated by adding the previous number 5 and 3. Its pretty simple , isnâ€™t it?. Lets now have a look at how we can generate the same sequence in Excel.

## How to Create Fibonacci Sequence in Microsoft Excel ?

1. Letâ€™s enter the value 0 in to cell A1 and value 1 in to cell A2
1. Add the first two numbers in cell A3 by using the formula A1 + A2.
1. Click on the lower right corner (fill handle) of the cell A3 and drag it down. You should see the Fibonacci sequence .

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021