Bisection Method Troubles

[lhargr2]

I have the following User Defined Function that I would prefer use the Bisection Method to arrive at a solution, but every time I try to implement it I freeze my Excel.

The script below works, but it clearly uses more computing power than it should:

Please Login or Register  to view this content.

I would rather it look more like below, but as shown it is freezing my Excel:

Please Login or Register  to view this content.

Notice that I need the Absolute Value when using Bisection because I don't know from which direction I'll converge like I do in the first scenario. Adding the Abs() to my first script also freezes it.

Can anyone shed some light on this? I feel like I'm missing something simple.

[shg]

Please Login or Register  to view this content.

10^-1000 is exactly zero in the double-precision floating-point format used by your computer and therefore Excel, and an absolute value can never be less than zero.