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

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

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

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