Thread: Excel Troubles
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mrmark[_4_] mrmark[_4_] is offline
external usenet poster
 
Posts: 1
Default Excel Troubles

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