Rearranging an equation: 56.25 = (0.0064 * y) + [(y *37 -156) * 0.138 / 37] + y

[XX32]

Hi All,
Would really appreciate it if someone could help me solve an equation.
I'm at work and use a lot of Excel formulas but have let some of my high school maths slip...:-(

I need to rearrange the following to solve for y:
56.25 = (0.0064 * y) + [(y *37 -156) * 0.138 / 37] + y

I know this works as I have used Goal Seek in Excel, where y = 49.66082.
What I need to do is to arrive at a formula that allows me to solve for a number of lines rather than using Goal Seek each time.

Any help with rearranging the formula and showing method so that I can learn how to do it for next time would be greatly appreciated.

Thanks for your time!
Alex

 

[Deleted member 4993]

Hi All,
Would really appreciate it if someone could help me solve an equation.
I'm at work and use a lot of Excel formulas but have let some of my high school maths slip...:-(

I need to rearrange the following to solve for y:
56.25 = (0.0064 * y) + [(y *37 -156) * 0.138 / 37] + y

I know this works as I have used Goal Seek in Excel, where y = 49.66082.
What I need to do is to arrive at a formula that allows me to solve for a number of lines rather than using Goal Seek each time.

Any help with rearranging the formula and showing method so that I can learn how to do it for next time would be greatly appreciated.

Thanks for your time!
Alex

First simplify this part.(in the form A * y - B, where A and B are numerical constants)

What do you get? What does the given equation look like with the simplified part?

 

[BrainTeaser556]

Wow! Just realised how quickly I have forgotten my high school maths also. Anyone with the answer should please share. I would be glad to learn also. thanks

 

[XX32]

Thanks for the help, starting to make more sense now.
Maybe time to hit the old school books !