software

Hi,

I'm trying to figure out this problem:

3x 2y = 16
5x - 3y = -5

What is x? What is y?

x=2 y=5

I can do it on paper. Can it be done in excel? If so, how?

Thank you,
John

Actually, x and y have infinite values. For example, using the 1st equation
[3x 2y = 16],
when...
x = 0, y = 8
x = 1, y = 6.5
x = 2, y = 5
etc, etc, etc

An example...
Cell Value
A1 0
A2 1
A3 2

B1 = =(16-(3*A1))/2
B2 = (16 -(3*A2))/2
B3 = (16 -(3*A3))/2

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;Johnquot; wrote:

gt; Hi,
gt;
gt; I'm trying to figure out this problem:
gt;
gt; 3x 2y = 16
gt; 5x - 3y = -5
gt;
gt; What is x? What is y?
gt;
gt; x=2 y=5
gt;
gt; I can do it on paper. Can it be done in excel? If so, how?
gt;
gt; Thank you,
gt; John
gt;

On Fri, 10 Mar 2006 10:16:30 -0800, Gary L Brown
gt; wrote:

gt;Actually, x and y have infinite values. For example, using the 1st equation
gt;[3x 2y = 16],
gt;when...
gt; x = 0, y = 8
gt; x = 1, y = 6.5
gt; x = 2, y = 5
gt;etc, etc, etc
gt;
gt;An example...
gt;Cell Value
gt;A1 0
gt;A2 1
gt;A3 2
gt;
gt;B1 = =(16-(3*A1))/2
gt;B2 = (16 -(3*A2))/2
gt;B3 = (16 -(3*A3))/2
gt;
gt;HTH,

Thanks for the assistance, Gary. Unfortunately, I wasn't specific
enough. Both equations are supposed to be part of the same problem. So
only when x=2 and y=5 will you solve both equations. The question is
how do you express this in excel.

Thanks.

quot;Johnquot; wrote:

gt; Hi,
gt;
gt; I'm trying to figure out this problem:
gt;
gt; 3x 2y = 16
gt; 5x - 3y = -5
gt;
gt; What is x? What is y?
gt;
gt; x=2 y=5
gt;
gt; I can do it on paper. Can it be done in excel? If so, how?
gt;
gt; Thank you,
gt; John
gt;

gt; 3x 2y = 16
gt; 5x - 3y = -5

If you place 3,2,16 in A1:A3
and 5,-3,-5 in B1:B3
then...

[x] = (B2*C1 - B1*C2)/(A1*B2 - A2*B1)

[y] = (A2*C1 - A1*C2)/(A2*B1 - A1*B2)

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Johnquot; gt; wrote in message
...
gt; On Fri, 10 Mar 2006 10:16:30 -0800, Gary L Brown
gt; gt; wrote:
gt;
gt;gt;Actually, x and y have infinite values. For example, using the 1st
gt;gt;equation
gt;gt;[3x 2y = 16],
gt;gt;when...
gt;gt; x = 0, y = 8
gt;gt; x = 1, y = 6.5
gt;gt; x = 2, y = 5
gt;gt;etc, etc, etc
gt;gt;
gt;gt;An example...
gt;gt;Cell Value
gt;gt;A1 0
gt;gt;A2 1
gt;gt;A3 2
gt;gt;
gt;gt;B1 = =(16-(3*A1))/2
gt;gt;B2 = (16 -(3*A2))/2
gt;gt;B3 = (16 -(3*A3))/2
gt;gt;
gt;gt;HTH,
gt;
gt; Thanks for the assistance, Gary. Unfortunately, I wasn't specific
gt; enough. Both equations are supposed to be part of the same problem. So
gt; only when x=2 and y=5 will you solve both equations. The question is
gt; how do you express this in excel.
gt;
gt; Thanks.
gt;
gt; quot;Johnquot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; I'm trying to figure out this problem:
gt;gt;
gt;gt; 3x 2y = 16
gt;gt; 5x - 3y = -5
gt;gt;
gt;gt; What is x? What is y?
gt;gt;
gt;gt; x=2 y=5
gt;gt;
gt;gt; I can do it on paper. Can it be done in excel? If so, how?
gt;gt;
gt;gt; Thank you,
gt;gt; John
gt;gt;
gt;gt; 3x 2y = 16
gt;gt; 5x - 3y = -5

I should have added. Another option is:

If you place 3,2,16 in A1:A3
and 5,-3,-5 in B1:B3
then select 2 vertical cells and array enter the following:

=MMULT(MINVERSE(A1:B2),C1:C2)

or select 2 horizontal cells and array enter the following:

=TRANSPOSE(MMULT(MINVERSE(A1:B2),C1:C2))

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Dana DeLouisquot; gt; wrote in message
...
gt;gt; 3x 2y = 16
gt;gt; 5x - 3y = -5
gt;
gt; If you place 3,2,16 in A1:A3
gt; and 5,-3,-5 in B1:B3
gt; then...
gt;
gt; [x] = (B2*C1 - B1*C2)/(A1*B2 - A2*B1)
gt;
gt; [y] = (A2*C1 - A1*C2)/(A2*B1 - A1*B2)
gt;
gt; --
gt; HTH. :gt;)
gt; Dana DeLouis
gt; Windows XP, Office 2003
gt;
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt;gt; On Fri, 10 Mar 2006 10:16:30 -0800, Gary L Brown
gt;gt; gt; wrote:
gt;gt;
gt;gt;gt;Actually, x and y have infinite values. For example, using the 1st
gt;gt;gt;equation
gt;gt;gt;[3x 2y = 16],
gt;gt;gt;when...
gt;gt;gt; x = 0, y = 8
gt;gt;gt; x = 1, y = 6.5
gt;gt;gt; x = 2, y = 5
gt;gt;gt;etc, etc, etc
gt;gt;gt;
gt;gt;gt;An example...
gt;gt;gt;Cell Value
gt;gt;gt;A1 0
gt;gt;gt;A2 1
gt;gt;gt;A3 2
gt;gt;gt;
gt;gt;gt;B1 = =(16-(3*A1))/2
gt;gt;gt;B2 = (16 -(3*A2))/2
gt;gt;gt;B3 = (16 -(3*A3))/2
gt;gt;gt;
gt;gt;gt;HTH,
gt;gt;
gt;gt; Thanks for the assistance, Gary. Unfortunately, I wasn't specific
gt;gt; enough. Both equations are supposed to be part of the same problem. So
gt;gt; only when x=2 and y=5 will you solve both equations. The question is
gt;gt; how do you express this in excel.
gt;gt;
gt;gt; Thanks.
gt;gt;
gt;gt; quot;Johnquot; wrote:
gt;gt;
gt;gt;gt; Hi,
gt;gt;gt;
gt;gt;gt; I'm trying to figure out this problem:
gt;gt;gt;
gt;gt;gt; 3x 2y = 16
gt;gt;gt; 5x - 3y = -5
gt;gt;gt;
gt;gt;gt; What is x? What is y?
gt;gt;gt;
gt;gt;gt; x=2 y=5
gt;gt;gt;
gt;gt;gt; I can do it on paper. Can it be done in excel? If so, how?
gt;gt;gt;
gt;gt;gt; Thank you,
gt;gt;gt; John
gt;gt;gt;
gt;
gt;
On Fri, 10 Mar 2006 14:08:59 -0500, quot;Dana DeLouisquot;
gt; wrote:

gt;gt;gt; 3x 2y = 16
gt;gt;gt; 5x - 3y = -5
gt;
gt;I should have added. Another option is:
gt;
gt;If you place 3,2,16 in A1:A3
gt;and 5,-3,-5 in B1:B3
gt;then select 2 vertical cells and array enter the following:
gt;
gt;=MMULT(MINVERSE(A1:B2),C1:C2)
gt;
gt;or select 2 horizontal cells and array enter the following:
gt;
gt;=TRANSPOSE(MMULT(MINVERSE(A1:B2),C1:C2))

Thank you for both posts. I very much appreciate it.

One question though, I notice for both examples above the answer in
the cell was 2 while when I clicked on the formula it showed {2,5}. Is
there a way to show both.

Thanks again,
John

The key part is to select 2 vertical cells and

ARRAY ENTER

the formula. That means you commit the formula by pressing

Ctrl-Shift-Enter

quot;Johnquot; wrote:

gt; On Fri, 10 Mar 2006 14:08:59 -0500, quot;Dana DeLouisquot;
gt; gt; wrote:
gt;
gt; gt;gt;gt; 3x 2y = 16
gt; gt;gt;gt; 5x - 3y = -5
gt; gt;
gt; gt;I should have added. Another option is:
gt; gt;
gt; gt;If you place 3,2,16 in A1:A3
gt; gt;and 5,-3,-5 in B1:B3
gt; gt;then select 2 vertical cells and array enter the following:
gt; gt;
gt; gt;=MMULT(MINVERSE(A1:B2),C1:C2)
gt; gt;
gt; gt;or select 2 horizontal cells and array enter the following:
gt; gt;
gt; gt;=TRANSPOSE(MMULT(MINVERSE(A1:B2),C1:C2))
gt;
gt; Thank you for both posts. I very much appreciate it.
gt;
gt; One question though, I notice for both examples above the answer in
gt; the cell was 2 while when I clicked on the formula it showed {2,5}. Is
gt; there a way to show both.
gt;
gt; Thanks again,
gt; John
gt;