Solving a formula
 

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)))

If I am not mistaken, x equals:

= 22176000000 / P6

HTH
--
Dana DeLouis
Win XP & Office 2003


"Anth" wrote in message
...
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)))

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)