In this article, we will learn **how to create the Fibonacci Calculator in Excel**. Numerous mathematical applications exist for the **Fibonacci **sequence. The **Fibonacci **sequence is also employed in computer algorithms and the determination of the golden ratio. And **Fibonacci Retracement** is a popular analysis tool in trade. Excel makes it simple to calculate the **Fibonacci **sequence and create a **Fibonacci Calculator**. So, without any delay, letâ€™s start the discussion.

## Download Practice Workbook

To practice by yourself, download the following workbook.

## What Is Fibonacci Number?

Fibonacci sequence is a set of integers starting with **0** and **1**. The next number in the sequence is found by adding the **2 **numbers before it. So, our **1st **and **2nd **Fibonacci numbers are **0 **and **1**. So, our next number is **0**+**1**=**1**. Similarly, the next number will be **1**+**1**=**2**. In this way, we can easily calculate the following numbers in the sequence by summing the **2 **previous numbers.

## Step-by-Step Procedures to Create Fibonacci Calculator in Excel

We will now create a **Fibonacci Calculator** in Excel. We will find out **Retracements **and **Extensions** using the input value for the up or down trend. Letâ€™s go through the steps below to see how it works.

### STEP 1: Insert Format of Fibonacci Calculator

- Firstly, we will insert a format of the calculator.
- In the following figure, we have our format for the
**Up Trend**.

### STEP 2: Add Retracements and Extensions in Calculator

- In the following step, you have to add
**retracements**and**extensions**in the format of the calculator. - Here, the common
**Fibonacci**ratios are**23.****6**%,**38.2**%,**50**%,**61.8**%,**78.6**%,**100**%, and**123.20**%. - Therefore, we will add
**RetracementsÂ**accordingly. - After that, we will also add
**Extensions**to the calculator.

### STEP 3: Link Between Cells to Create Calculator

- In the following figure, we will link between input and output in the calculator.
- Therefore, you have to link between
**retracement**and**extension**cells and input cells. - Here,
**High**and**Low**are our input. - Then, write the following formula in the
**F5**cell:

`=$C$6-$C$8*E5`

- After that, press
**Enter**to exit from the editing mode.

Here, **$C$6-$C$8*E5** indicates that we will use the formula for a specific **Retracement **that isÂ **High Value â€“ Net Up*Retracement.**

- After that, we will
**drag down**the formula in the**Retracements**column using the following (**+**) icon.

- As a result, the formula is applied to the column.
- The column is showing the value
**0**as we have not inserted the input value yet.

- In the following step, write the following formula in the
**I5**cell:

`=$C$6+$C$8*H5`

- After that, press
**Enter**to exit from the editing mode.

Here, **$C$6+$C$8*H5** indicates that we will use the formula for a specific **Extension **that is **High Value + Net Up*Extension.**

- Next,
**drag down**the formula in the**Extensions**column using the**Fill Handle**.

- As a result, the formula is now inserted into the
**ExtensionsÂ**column. - But, the result is showing
**0**as we have not inserted the value in the input.

- In the next step, we need the value of
**Net Up**. - For this reason, we need to calculate the value of
**Net Up.** - So, write the following formula in the
**C8**cell:

`=C6-C7`

- Then, click
**Enter**to proceed.

### STEP 4: Insert Format for Down Trend

- Similarly, for the
**Down Trend,**we will add**Retracements**and**Extensions**.

- In the following step, we need to write down the formula to calculate
**Retracements**for the**Down Trend**. - So, write down the following formula in the
**F14**cell:

`=$C$16+$C$17*E14`

Here, **$C$16+$C$17*E14** indicates that we are using the formula for a specific **Down Trend** **retracement** that is **Low Value + Net Down*Retracement**.

- Next,
**drag down**the formula in the**Retracements**column using the**Fill Handle**.

- Now, we need to write down the formula to calculate
**Extensions**for the**Downtrend**. - So, write down the following formula in the
**I14**cell:

`=$C$16-$C$17*H14`

Here, **$C$16-$C$17*H14** indicates that we are using the formula for a specific **Down Trend** **Extension** that is **Low Value â€“ Net Down*Extension**.

- Then,
**drag down**the formula in the**Extensions**column using the**Fill Handle**.

- But, we do not want to insert the input
**2Â**times. - We want to insert the input for a single time and show the output for
**Up**and**Down Trend Retracements**and**Extensions**. - Thatâ€™s why create a link between the inputs of
**Up Trend**and**Down Trend**. - Therefore, in the
**C15**cell, insert the following formula in the formula bar:

`=C6`

- Then, press
**Enter**to exit from the editing mode. - As a result, what we insert in the
**C6**cell as input will show in the**C15Â**cell.

- After that,
**drag down**the formula using the**Fill Handle**to link the**Low**and**NetÂ**values.

### Final Output

- Finally, our
**Fibonacci Calculator**is ready. - Here, we need to insert the input in the
**C6**and**C7Â**cells. - So, inserting the
**High**value in**C6**and the**Low**value in**C7**will show the result.

- For checking the calculator, insert the
**High**value as**100**and the**Low**value as**50**. - As a result,
**Retracements**and**Extensions**for**Up**and**Down Trends**are showing.

- Again, check for another value.
- So, insert the
**High**value as**100**and the**Low**value as**50**. - As a result,
**Retracements**and**Extensions**for**Up**and**Down Trends**are showing.

## How to Generate Fibonacci Sequence in Excel

We will now generate **Fibonacci SequenceÂ in Exce**l. In **1st **column, we will show the **serial number** and the corresponding **Fibonacci number **in the **2nd **column. Letâ€™s go through the steps below to see how it works.

### STEP 1: Insert Initial Sequence of Fibonacci Number

- Firstly, we have to give input the first
**2**numbers of the**Fibonacci**sequence. - The first
**2**numbers of the**Fibonacci**sequence are**0**and**1**. - Therefore, in cell
**C5**, insert the number**0**. - This indicates that
**1st**number of the**Fibonacci**series is**0**. - Similarly, in the
**C6**cell, give the input as**1**. - It indicates that the
**2nd**number of the**Fibonacci**series is**1**. - Now, we will show you the next components of the
**Fibonacci**series.

**Read More: ****How to Create a Fibonacci Pivot Point Calculator in Excel**

### STEP 2: Apply Formula to Calculate Next Sequence

- In the following step, we will calculate the
**3rd**number of the sequence. - So, insert the following formula in the formula bar of the
**C7**cell.

`=C5+C6`

- As a result, we can see the
**3rd**serial of the**FibonacciÂ**sequence.

- Instead of inserting the serial number manually, we can also generate the
**Serial**column inÂ**Excel**. - So, write down the following formula in the
**B8**cell to sequentially increase the**Serial**column:

`=B7+1`

- In the following step, we will
**drag down**the formula in the**Serial**column using the following (**+**) icon to generate the serial number.

- Similarly, we will drag down the formula of the
**Fibonacci**sequence in the**Fibonacci NumberÂ**column.

**Read More:Â ****How to Make a Calculator in Excel (with Easy Steps)**

### Final Output

- Finally, we have been able to calculate the
**Fibonacci**number in**Excel**. - By
**drill**â€“**down**option, you can extend the sequence as per your requirements.

**Read More:**** How to Create Drill Down in Excel (with Easy Steps)**

## Conclusion

In this article, we have demonstrated step-by-step procedures for **creating a Fibonacci calculator in Excel**. There is a practice workbook at the beginning of the article. Go ahead and give it a try. To read similar articles, check out the **ExcelDemy **website. Last but not least, please use the **comment section** below to post any questions or make any suggestions you might have.

**Related Articles**

**Create Venn Diagram from Pivot Table in Excel (2 Ways)****How to Calculate Root Mean Square Error in Excel****Recalculate in Excel (3 Effective Methods)****How to Perform Bootstrapping in Excel (with Easy Steps)****Make a Recalculate Button in Excel (with Easy Steps)****How to Force Recalculation with VBA in Excel****Calculate Bootstrapping Spot Rates in Excel (2 Examples)****How to Create a Calculator Using Macros in Excel (with Easy Steps)**