This video is about the solution of the Newton-Raphson Method in excel and visual basic (VBA) to find the root of the non-linear equation. The tutorial consists of:

  1. Theory of Newton Raphson Method
  2. Solution of Newton Raphson Method in Excel
  3. Solution of Newton Raphson Method in VBA

Download starter file

The final expression of the Newton-Raphson method can be written as:

The solution steps can be summarized as:

  1. Choose a guess value x.
  2. Find the value of f(x) and f’(x).
  3. Estimate the next value of x using the given equation and calculate the function value.
  4. If x is not the root of f(x) then repeat steps 2 & 3 until f(xi) = 0 within specified accuracy.

Please like and follow us on:

  • Facebook:
  • Instagram:
  • LinkedIn:

Join the Facebook group for interactive learning:

For any queries please write: