# How to Create Fibonacci Calculator in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.

## 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.

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

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â€™s Retracement which 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 Down Trend.
• 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â€™s 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â€™s 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 the Fibonacci SequenceÂ in Excel. 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.

### 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.

### Final Output

• Finally, we have been able to calculate the Fibonacci number in Excel.
• By the drag down option, you can extend the sequence as per your requirements.

To practice by yourself, download the following workbook.

## 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.Â Last but not least, please use the comment section below to post any questions or make any suggestions you might have.

## Related Articles

<< Go Back to Finance Template |Â Excel Templates

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sudipta Chandra Sarker

Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF