Equation into Excel using PEMDAS

[Spasmodic]

Hello All,

I am trying to put formula A13 into Excel but am not sure how to write it using PEMDAS. Any help would be appreciated as I can just plug in the numbers for things like Pmax and etc. Thank you in advance.

http://download.lww.com/wolterskluw.../MSS_44_2_2011_12_14_SAMOZINO_202175_SDC1.pdf

 

[Spasmodic]

A12=(-(g^2)/(3*Pmax)) - ((-(g^4*hpo^4)-12*g*hpo^3*Pmax^2)/(3*hpo^2*Pmax*Z(Pmax,hpo))) - (Z(Pmax,hpo)/(3*hpo^2*Pmax)) where I have Z(Pmax,hpo) referencing the cell with the formula you gave

Z(Pmax,hpo) is in cell B1

 

[shg]

Could you PLEASE post the actual formula you have in the cell?

 

[Spasmodic]

A12 = (-(H4^2)/(3*K8)-((-(H4^4*G4^4)-12*H4*G4^3*K8^2)/(3*G4^2*K8*N8)))-(N8)/(3*G4^2*K8)

Z (Which is in cell N8) = (-(H4^6)*G4^6-18*H4^3*K8^2-54*G4^4*K8^4+6*SQRT(3)*SQRT(2*H4^3*G4^9*K8^6+27*G4^8*K8^8))^(1/3)

 

[shg]

You're missing an hp0 term in Z:

	G​	H​	K​	N​	O​
1​	SFv​
2​	-32.0437​				G2: = -(g^2)/(3 * Pmax) - (-(g^4 * hp0^4) - 12 * g * hp0^3 * Pmax^2) / (3 * hp0^2 * Pmax * Z) - Z/(3 * hp0^2 * Pmax)
3​	hp0​	g​
4​	0.5​	9.8​
5​
6​
7​			Pmax​	Z​
8​			1​	-24.3028​	N8: =(-(g^6) * hp0^6 - 18 * g^3 * hp0^5 * Pmax^2 - 54 * hp0^4 * Pmax^4 + 6 * SQRT(3) * SQRT(2 * g^3 * hp0^9 * Pmax^6 + 27 * hp0^8 * Pmax^8))^(1/3)

Everything else look correct to me.

 

[shg]

You're missing an hp0 term in Z

Probably because it's missing in my first post

 

[Spasmodic]

Ahhh, it's finally yielding a number that looks correct! Thank you very much for the help. I wouldn't have been able to figure this out without you, very much appreciated.

 

[shg]

You're welcome, glad you got it sorted.