View original (French)

Automatically solve an equation in Excel

seblg29 -  
Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   -
Hello,

I would like to solve an equation in Excel, but I'm a bit stuck.

Here is the equation:
Y = a*x + b*y
Knowing that:
Y = 55
x = 40
y = 60

How can I set up an equation in Excel to automatically find a and b?
Thank you in advance,

4 answers

  1.
    via55 Posted messages 14391 Registration date   Status Member Last intervention   2 759
     
    Hello

    Your equation has 2 unknowns, so you need a second equation and a system of equations in order to solve it by hand or with Excel

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    0
    1. seblg29
       
      I thought so.
      In that case, see my system:

      Y = a*x + b*y
      Z = c*x + d*y
      Knowing that:
      Z = 50
      Y = 55
      x = 40
      y = 60

      How to solve this in Excel?
      Best regards,
      1