If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Finding roots of non-linear equations in Excel
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. Any ideas how to get this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge help again | DrB | Worksheet Functions | 4 | June 20th, 2004 05:59 PM |
Field code to pick up Excel sheet | Lyndie | Mailmerge | 1 | June 2nd, 2004 11:57 AM |
Problems using Excel 97 worksheet in Excel 2002 | plfoley | Worksheet Functions | 1 | May 2nd, 2004 09:54 AM |
Cant open excel files by double clicking it | Maged N. Roshdy | Setting up and Configuration | 1 | February 4th, 2004 09:35 AM |
Excel Freezes at Start-Up (RegEdit to the rescue?) | [email protected] | Setting up and Configuration | 0 | October 22nd, 2003 12:38 PM |