Introduction

I have wanted to make a goal seek function where you can make something like = SUM(…), but with =GOAL_SEEK(…). I had tried this before AI but it was necessary to re-write the formulas in excel that go from the input that drives the goal seek (for example, the price), all the way to the end (for example, NPV). This was a complete pain before AI because you would have to write the formulas on a manual basis (for example, Revenues(period) = Price x Quantity(Period) and all of the other formulas down to NPV).

Bisectional Method and Newton Method

.

.

.

.

Goal Seek Macro from Bi-Sectional and Newton

.

.