solving equations using Excel

[arnold_charming]

Hi!

I want to use Excel to solve an equation. How to do this and with which
tools? Below is my equation.

y = 0,75y + 0,4x
x = 0,25y + 0,6x
1 = y + x

I need the value of y and x. Please help me out. Tnx.

 

[Stephen]

"arnold_charming"

Hi!

I want to use Excel to solve an equation. How to do this and with which
tools? Below is my equation.

y = 0,75y + 0,4x
x = 0,25y + 0,6x
1 = y + x

I need the value of y and x. Please help me out. Tnx.

You don't need Excel to do this. To 4 decimal places:
x = 0.3846
y = 0.6154

Accurately:
x = 1/2.6
y = 1-x

 

[arnold_charming]

"arnold_charming"
<[email protected]> wrot
in
messag


You don't need Excel to do this. To 4 decimal places:
x = 0.3846
y = 0.6154

Accurately:
x = 1/2.6
y = 1-x

Tnx, but no tnx You solved this by hand and I need a genera
(automatic) solution. What will you do if I add additional 2 variable
(z, k). New equations for instance:

y = 0,75y + 0,4x + 0,1z + 0,6k
x = 0,15y + 0,3x + 0,3z + 0,1k
z = 0,05y + 0,1x + 0,2z + 0,2k
k = 0,05y + 0,2x + 0,4z + 0,1k
1 = y + x + z +

 

[Mike Middleton]

arnold_charming

What will you do if I add additional 2 variables ... <

In that case I would probably go to google.groups, type in "solving
equations using Excel," and try one of the many solutions shown there.

- Mike
www.mikemiddleton.com