Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a equation that you can solve only by trial an error, but I wan
excel to do the work for me. The equation is this 1/(X^.5)=2Log(C*X^.5)-.8 Where c is some constant that isant worth mentioning ;) and the Log is base 10. Ok I need a macro that will keep trying values untill one side is equa to the other up to .001 decimal places. I tried making some sort o random function generator, but it seems like the random function kep repeating certain values. Any advice/help is appericated. -Mar -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Header - Auto Format troubles | Excel Discussion (Misc queries) | |||
Excel 2007 Formula troubles | Excel Worksheet Functions | |||
Excel troubles | Excel Worksheet Functions | |||
troubles with the Workbooks.Open method in Excel 97 | Excel Programming | |||
saving *.xls files but troubles with opening with MS Excel | Excel Programming |