I have a long equation that I am trying solve for a particular variable so I can put it into Excel.

Background: The equation is for a tolerance allocation problem using an estimated mean shift model with user defined component deviations (6sigma or anything you like), and proportional scaling. I have solved the equation to find the total assembly tolerance, but now I need to re-solve for P, the Proportional Scaling Factor.

I can't get excel to solve it (mostly because I don't know how). I downloaded a mathematica trial version, and it solves my equation for P, but it won't allow me to see the whole answer, or to do anything useful with it.

Can anybody help? In the following equation, I want to solve for E70 (which is equal to P)

Tasm=(J28*E28+J29*E29+J30*E30+J31*E31+J32*E32+J35*E35+J36*E36+J37*E37+

J38*E38+J39*E39)+E68*E67*(

**SQRT((((E28/H28)^2)*(1-J28)^2)+**

(((E29/H29)^2)*(1-J29)^2)+(((E30/H30)^2)*(1-J30)^2)+(((E31/H31)^2)*

(1-J31)^2)+(((E32/H32)^2)*(1-J32)^2)+(((E35/H35)^2)*(1-J35)^2)+

(((E36/H36)^2)*(1-J36)^2)+(((E37/H37)^2)*(1-J37)^2)+(((E38/H38)^2)*(

1-J38)^2)+(((E39/H39)^2)*(1-J39)^2)))

(((E29/H29)^2)*(1-J29)^2)+(((E30/H30)^2)*(1-J30)^2)+(((E31/H31)^2)*

(1-J31)^2)+(((E32/H32)^2)*(1-J32)^2)+(((E35/H35)^2)*(1-J35)^2)+

(((E36/H36)^2)*(1-J36)^2)+(((E37/H37)^2)*(1-J37)^2)+(((E38/H38)^2)*(

1-J38)^2)+(((E39/H39)^2)*(1-J39)^2))

I have

**bolded**the square root portion to try to avoid confusion.

To evaluate in Excel you will need to remove the 'Tasm=' part. Obviously I am referencing cells from my spreadsheet.

For Mathematica, I believe the SQRT command (entire 2nd line)needs to be changed.

Any help is greatly appreciated!!!