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

[wasya152]

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.

 

[christianjb]

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.

 

[wasya152]

thanks. that really helped. and unfortunately i don't have a mac.

 

[ice109]

solve? meaning what?

 

[Zurtex]

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:

³²⁰/_x + y = z

Now if y and z are an integer, that means ³²⁰/_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.

 

[uart]

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