| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solving for multiple algebraic variables
Dear gurus, I'm trying to transcribe a complicated problem for a large project onto an excel sheet to give me 4092 sets of answers rather than me calculate each set by hand. In my case I'm ultimately solving for twelve variables. (if, I were to try graphing, it would take 12 dimensions). ------------- Simply put: How do you solve for a variable when the equation is not in the terms of the variable? For example: x+2=3 My equation is too complicated to be transcribed as 3-2=x. Does excel support this? ------------ Many thanks in advance for anyone who can help me! Sincerely, Chris P.S. If this is not written clearly, then I will gladly clarify. -- punkorganist ------------------------------------------------------------------------ punkorganist's Profile: http://www.excelforum.com/member.php...o&userid=35699 View this thread: http://www.excelforum.com/showthread...hreadid=554827 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solving for multiple algebraic variables
Try the solver add in, i don't knowif this will help ToolsAddinsSolver
-- RWS "punkorganist" wrote: Dear gurus, I'm trying to transcribe a complicated problem for a large project onto an excel sheet to give me 4092 sets of answers rather than me calculate each set by hand. In my case I'm ultimately solving for twelve variables. (if, I were to try graphing, it would take 12 dimensions). ------------- Simply put: How do you solve for a variable when the equation is not in the terms of the variable? For example: x+2=3 My equation is too complicated to be transcribed as 3-2=x. Does excel support this? ------------ Many thanks in advance for anyone who can help me! Sincerely, Chris P.S. If this is not written clearly, then I will gladly clarify. -- punkorganist ------------------------------------------------------------------------ punkorganist's Profile: http://www.excelforum.com/member.php...o&userid=35699 View this thread: http://www.excelforum.com/showthread...hreadid=554827 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solving for multiple algebraic variables
Many MANY^23875 thanks!!!! -- punkorganist ------------------------------------------------------------------------ punkorganist's Profile: http://www.excelforum.com/member.php...o&userid=35699 View this thread: http://www.excelforum.com/showthread...hreadid=554827 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solving for multiple algebraic variables
Do you have more information on the equations you are trying to solve? Are they linear equations? over 4000 solutions in 12 variables sounds like they are not. I would try Mathematica, Maple, or some other symbolic math program. -- RonnieD ------------------------------------------------------------------------ RonnieD's Profile: http://www.excelforum.com/member.php...o&userid=35736 View this thread: http://www.excelforum.com/showthread...hreadid=554827 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RE-submitting of: constructing (complex) variables with worksheet functions | Excel Worksheet Functions | |||
| Bubble Charts with two non-numerical variables | Excel Worksheet Functions | |||
| constructing (complex) variables with worksheet functions | Excel Discussion (Misc queries) | |||
| VBA reseting variables | Excel Discussion (Misc queries) | |||
| Passing Variables | Excel Discussion (Misc queries) | |||
Linear Mode
