Help with a math formula in Excel

[chucknorrisbeard]

Good day, I need help solving for this formula: x=1+(1-u^2 )(ca^2-1)+u^2/√m(cp^2-1). x is supposed to be 0.81. ca=0.5, cp=1, u=0.73 and m=3. I am by no means a math or excel master and any assistance would be much appreciated.

This is the formula I use however I end up with 0.65.

=1+(1-U25^2)*(U20^2-1)+((U25^2)/SQRT(U24))*(U21^2-1)

 

[Eric W]

The first 2 terms look ok, and they add up to about .65. Your third term looks iffy. Somehow the parentheses aren't right. When cp = 1, then (cp^2 - 1) = 0. So when you multiply the rest of that term by 0, it all goes to 0. Check to make sure that is correct.

 

[Michael M]

Aslight mod returns 0.87019 ??

=1+(1-U25^2)*(U20^2-1)+(U25^2)/SQRT((U24)*(U21^2-1))