Hi all, first post on the forum so please be gentle with me if I break any specific forum etiquette!
I have a spreadsheet that I would like to run through Spreadsheet Converter to turn it into a Flash or HTML file for use on a webpage, however I have been informed by the support team at SC that their software cannot make use of the Solver or any macro functions. Unfortunately Solver forms the core feature of the spreadsheet, so without it I cannot create the webpage.
I am looking for a way to solve a rather complex equation fx=0 ( fx consists of around 20 inputs each used 3 to 4 times) by altering 1 specific input. Solver does this nicely, I am not familiar with macros but I imagine they would also make light work of it, however since they are not supported, that is a moot point.
So, my question would be, can I replicate the solver feature using just basic functions within the spreadsheet, and without significantly re-arranging the equation in question?
I am attempting to come to solution myself using a small mock up:
\1
(I see [img] tags do not work here?)
I want AB-C2D=0 by altering D. Obviously this one would be easy to do with a quick re-arrangement however I would really rather avoid that route if possible given the complexity of the equation I am actually attempting to solve.
Thanks in advance for any help or suggestions!
Bookmarks