View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
 
Posts: n/a
Default Two unknown variable equation

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?''.


"John" wrote:

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