Solving a formula

A

Anth

I have the following formula that I need Excel to solve for different values
of P6 ( I have different values of P6 (P7, P8, P9 (reference cells)). I need
the value of x for the different values of P6. Is this possible? It seems
like it should be but I can't find out how to make Excel do this. Please
help! Thanks.

70000 = P6*((((x/80)*(1/5280))*(2/3))+(((x/40)*(1/5280))*(1/3)))
 
M

Marvin P. Winterbottom

you first have to solve the equation for x, in other words, get x on one side
by itself, and excel can't do that for you.
HINT- it involves multiplying (1/5280) * (2/3) and (1/5280) * (1/3)
 
Top