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"
<arnold_charming.1zod5n_1133967301.3924@excelforum-nospam.com> wrote in
message news:arnold_charming.1zod5n_1133967301.3924@excelforum-nospam.com...
>
> 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.
>
>
> --
> arnold_charming

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"
<arnold_charming.1zod5n_1133967301.3924@excelforum-nospam.com> wrote in
message news:arnold_charming.1zod5n_1133967301.3924@excelforum-nospam.com...
>
> 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.
>
>
> --
> arnold_charming

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 general (automatic) solution. What will you do if I add additional 2 variables (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 + k

[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