Formula with 2 unknowns

L

LAF

I have the following formula:
100=(D9+D10)-(0.15*D9)-(0.05*D10)

Cells D9 and D10 are unknown. Is there a way to find out what they ca
be to make the equation true
 
B

BenjieLop

If you algebraically manipulate your equation, you will come out with

D9 = (100- (0.95*D10))/0.85

and from the above equation, you can do this:

1. Enter the formula =(100-(0.95*D10))/0.85 in Cell D9

2. Cell D10 is where you enter various values

And for every value entered in Cell D10, a corresponding value wil
come out in D9.

Hope this solution will help you solve this
 
Top