Home MS Excel TutorialExcelTips and Tricks How To Use Newton’s Method In Excel

How To Use Newton’s Method In Excel

by Easy Excel Tutorials

How To Use Newton’s Method

Follow the steps below to learn how to use Newton’s Method in Excel.

We are going to use Newton Method to solve the equation x^2=5

First you need to label the column like this


Note: (x), a column for the function evaluations (f(x)), and a column for the slope (f’(x))

Enter value in (x). In column B write the formula =A2^2-5 and in column C write the formula 2*A2


In column A cell A3 enter formula


Select cell B2, move cursor to the bottom right, a black plus sign will appear. Drag the black plus sign to cell B7.


Repeat with cell C2.


Repeat with cell A1. That’s it, you have now learned how to use Newton Method in Excel.


Note: Once the value of x stops changing from row to row and f(x) is small (close to zero), you have the solution (assuming the process converged).


Note: Answer is shaded in yellow.


You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References

You may also like