Solve 320+(x*y)=x*z for x: Excel Formula & Analysis Tips

  • Thread starter wasya152
  • Start date
In summary, The equation is x = 320/(z-y) and the person is trying to determine the value of x where both sides will be equal. They are also looking for help in converting the equation into an excel formula and discussing possible restrictions on the problem.
  • #1
wasya152
2
0
i'm going an analysis for work, but at stuck at this point. it's been a while since i took math or really used it to this extent. i need to know what the equation would look like in order to solve at what x will both sides be equal. need to put it in as an excel formula. thanks all help is greatly appreciated.
 
Mathematics news on Phys.org
  • #2
rearranging:

x=320/(z-y)

Do you have access to a Mac? Its 3D 'grapher' program will show you what this looks like in an instant.
 
  • #3
thanks. that really helped. and unfortunately i don't have a mac.
 
  • #4
solve? meaning what?
 
  • #5
wasya152 said:
i'm going an analysis for work, but at stuck at this point. it's been a while since i took math or really used it to this extent. i need to know what the equation would look like in order to solve at what x will both sides be equal. need to put it in as an excel formula. thanks all help is greatly appreciated.

I'm going to take a guess here (because it makes the problem a little more interesting) and assume that x, y and z have to be integer positive numbers? In which case look at it like this:

320/x + y = z

Now if y and z are an integer, that means 320/x has to be, so what are the only possible values of x?

While you can determine the possible values of x, you can only determine a linear (with constant) relationship between y and z, not unless there is some sort of other restriction on the problem.
 
  • #6
Zurtex said:
I'm going to take a guess here (because it makes the problem a little more interesting) and assume that x, y and z have to be integer positive numbers?

Yes it makes it more interesting but I'm pretty sure that the OP wanted nothing more than to make x the subject of the formula. :)

to solve at what x will both sides be equal. need to put it in as an excel formula
 
Last edited:

FAQ: Solve 320+(x*y)=x*z for x: Excel Formula & Analysis Tips

How do I solve the equation 320+(x*y)=x*z?

To solve this equation, you can use basic algebraic principles like distributive property and combining like terms. First, distribute the x in x*y to get 320+x^2*y = x*z. Then, subtract 320 from both sides to get x^2*y = x*z - 320. Finally, divide both sides by x to get the final solution of x*y = z - 320/x.

What are the variables in this equation?

The variables in this equation are x, y, and z. These represent unknown values that we are trying to solve for.

Can I solve this equation without knowing the exact values of x, y, and z?

Yes, you can still solve this equation without knowing the exact values of x, y, and z. However, the final solution will be in terms of these variables instead of a specific numerical value.

What is the purpose of using algebra to solve equations?

The purpose of using algebra to solve equations is to find the values of unknown variables and to understand the relationships between different quantities. It allows us to manipulate equations and solve for specific values, which is useful in many scientific and mathematical applications.

Can I use a calculator to solve this equation?

Yes, you can use a calculator to solve this equation. However, it is important to note that calculators may not always give exact solutions and may round off values. It is recommended to use a calculator only as a tool and to check your final solution by hand to ensure accuracy.

Similar threads

Back
Top