Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Equation
he is possivel to decide an equation as this in excel? 100-500+400-10X=0 thanks for any help paulo from portugal -- paulo_jorge_34 ------------------------------------------------------------------------ paulo_jorge_34's Profile: http://www.excelforum.com/member.php...o&userid=24297 View this thread: http://www.excelforum.com/showthread...hreadid=379036 |
#2
|
|||
|
|||
Yes it is. In your case: A........B...........................C 10....=100-500+400.......=MMULT(MINVERSE(A1),B1) The formula in C1 must be confirmed by holding down Ctrl and Shift, and then hit Enter. This will also work for larger equations (i.e. x,y,z) If the formula don't find a solution, it will return #VALUE! Hope it helped Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=379036 |
#3
|
|||
|
|||
How would the formula change if you wanted to use x, y, and z? -- carlyman ------------------------------------------------------------------------ carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440 View this thread: http://www.excelforum.com/showthread...hreadid=379036 |
#4
|
|||
|
|||
Here is how to work with multiple unknow. This comes from one of J.Walk's old newsletter - they are still worth reading. Ola Sandström POWER FORMULA TECHNIQUE By Alab Beban Here is an example of how to solve a set of simultaneous equations using Excel. Start with equations that are linearly independent so that there is, in fact, a solution; e.g., 17 = 5x + 3y + 2z 13 = 2x + 4y + z 22 = 3x + 2y + 5z Put the coefficients of the unknowns in, e.g., A1:C3 (i.e., 5,3,2 in A1:C1, 2,4,1 in A2:C2, etc.); Put the constants (17, 13, 22) in, e.g., D1:D3; Highlight, e.g., E1:E3 and array enter (i.e., enter with Ctrl+Shift+Enter instead of just Enter) =MMULT(MINVERSE(A1:C3,D1:D3) and the solution vector (1,2,3) will appear in E1:E3; i.e., x=1, y=2, z=3 For a set of equations that does not have a solution, the #VALUE error will appear in E1:E3. -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=379036 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is mathematical equation for NORMDIST (x,mean,standard_dev,TR | Excel Worksheet Functions | |||
Rounding in Trendline Equation | Charts and Charting in Excel | |||
Logarithmic Trendline Equation | Charts and Charting in Excel | |||
how do I graph a linear equation? | Charts and Charting in Excel | |||
equation problem | Excel Worksheet Functions |