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

  • Context: High School 
  • Thread starter Thread starter wasya152
  • Start date Start date
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
Sign up Log in
5 replies · 3K views
wasya152
Messages
2
Reaction score
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
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.
 
thanks. that really helped. and unfortunately i don't have a mac.
 
solve? meaning what?
 
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.
 
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: