Help converting math notation to Excel formula

[rkaczano]

I am trying to recreate a mathematical formula below in Excel. I cannot get it work and am hoping a second set of eyes my helf

I have pasted an image of the actual formula and written it out below with its answer.

= 1.1494 ∗ 10^−3 * ( 288.7 /101 ) * [ (7000^2 − 𝑒^0.0016 2800^2 )/(0.0696 ∗ 288.15 ∗ 500.4 ∗ 1.031 ∗ 0.009)^ 0.5 * 895.3^2.5
= 51,255,602.23 (Right answer)

I am getting the wrong answer and I think this issue is with the term "𝑒^0.0016 2800^2 ". As written in the attachment there is a space between "𝑒^0.0016" and "2800^2" and I am wondering if I am not addressing this properly using the EXP function. I assumed those terms are being multiplied. Either that or I have an issues with my brackets.

My attempt in Excel and the incorrect answer
=1.1494*10^-3*(288.7/101)*((7000^2-(EXP(0.0016)*2800^2))/(0.0696*288.15*500.4+(1.031*0.009)))^0.5*(895^2.5)
= 5,041,420 (Wrong Answer)

 

[Z51]

Here's how I'd enter the formula shown in the image. Note that in your formula (with the wrong answer), you're adding the product of 1.031 and 0.009 - and I'm not sure why as that's not in the image or the "right answer" version of the formula.

=(1.1494*10^-3)*(288.7/101)*((((7000^2)-(EXP(0.0016)*(2800^2)))/(0.0696*288.15*500.4*1.031*0.009))^0.5)*(895.3^2.5)

This formula returns 52,380,101.57. It's a lot closer to the "correct" answer, but still off.

 

[Alex Blakenburg]

I got the same result as Z51.
If you make the changes below you will also get Z51's figure.

 

[Leo Skywalker]

Same result, too.

=1.1494*10^-3  *  288.7/101  *  (  (7000^2-EXP(0.0016)*2800^2)   /   (0.0696*288.15*500.4*1.031*0.009)   )^0.5  *   895.3^2.5

Also named cells as variables to have the formula:

=1.1494*10^-3 * Tb/Pb * (   ( P.1^2 - EXP(s)*P.2^2 )   /   ( G*Tf*Le*Z*f )    )^0.5  * D^2.5

and the result was the same: 52,380,101.5734644

I guess a small change in the values of the variables can change the result quite a bit.