View Single Post
  #2  
Old July 27th, 2004, 09:43 PM
hgrove
external usenet poster
 
Posts: n/a
Default Finding roots of non-linear equations in Excel

TCO wrote...
I would like to find the first 20 or so POSITIVE roots of the
following equation:

A1=ATAN((2*A1*4)/(A1^2-16))/2

I have the "iteration" option turned on in the Solver
preferences. The first root is of course zero, however, I need
only the next 20 or so positive roots.


Unlcear what you want, but if you had read online help for Solver you
would have found out that Solver's Iteration parameter controls the
iterative procedure Solver uses to find zeros of functions and has
nothing whatsoever to do with specifying the number of zeros you want.

If you want multiple solutions, then the only way to get 'em is to
isolate them manually and use constraints to restrict Solver to those
ranges when isolating the zeros.


---
Message posted from http://www.ExcelForum.com/