Break even formula for a minimum value

[TruffleOil]

Hi everyone,

I have the following table with two different adjusters: X and Y. A3, B3, C3 are all fixed values and D3 and E3 are input variables.
Then, the Final Change (F3) is the following formula: =((B3+(C3*E3))+(A3*D3))

My goal is: figure out a formula to find out the minimum Assumption Y (E3) value that would break even the Final Change result to be equal to 0. In this example, for Assumption X = -15, the break even value of Assumption Y would be around 6,5 (calculated manually); below that, the Final Change would be a negative value.

Would appreciate any suggestion!
Thank you in advance!

 

[Mortiray]

What you're essentially trying to find is the appropriate E3 value so that ((B3+(C3*E3)+(A3*D3))=0. Solving for E3, your formula should be

-((A3*D3)-B3)/C3.

 

[TruffleOil]

What you're essentially trying to find is the appropriate E3 value so that ((B3+(C3*E3)+(A3*D3))=0. Solving for E3, your formula should be

-((A3*D3)-B3)/C3.

Thank you, but it didn't work.. and I don't want to replace the E3 value because it's an input for several values to see the different results of F3, even higher than 0. I just want to know separately (in G3) the minimum hypothetical value of E3 to reach the F3=0

 

[keef2]

Could you use the Solver add-in from excel? Not sure if this is what you meant.

 

[Mortiray]

Thank you, but it didn't work.. and I don't want to replace the E3 value because it's an input for several values to see the different results of F3, even higher than 0. I just want to know separately (in G3) the minimum hypothetical value of E3 to reach the F3=0

The formula doesn't need to replace E3, it can go anywhere. Try putting a 0 before it, like

=0-(((A3*D3)-B3)/C3)

 

[TruffleOil]

The formula doesn't need to replace E3, it can go anywhere. Try putting a 0 before it, like

=0-(((A3*D3)-B3)/C3)

ah ok, it worked now, I had to tweak a bit the formula with parenthesis but it works now. it was actually pretty straighforward but I didn't even think of it. thank you!!

 

[TruffleOil]

Could you use the Solver add-in from excel? Not sure if this is what you meant.

View attachment 77475

View attachment 77476

This also worked, thank you!!

Could you use the Solver add-in from excel? Not sure if this is what you meant.

View attachment 77475

View attachment 77476

this also worked, thank you!!