### Title

Exp Function not working how I want it too – help please!

### Post

I am transporting a formula from excel to filemaker and up to a point everything is fine. There is 1 line that is not returning the result I am after.

the line is:

**30 * Exp ( - ((( z - 275) / 25 ) ^ 2 ))**

*the value of "z" is 45.2070721 in this case, and the above function should return a value of 6.089.*

I think it is getting stuck on the "**-**" in the brackets. This function works fine in excel, but not here. The excel formula looks like this:

**=30*EXP(-(((C26-275)/25)^2))**

If anyone has any ideas I would be most greatful since this is one of the last of 20 lines in a formula.

Excel gives approximately 7.91E-82. I concur with Comment that the FMP Sin function is the problem as it is returning 0.

…and interestingly enough, if I remove the Sin function from the Excel equation, it gives the same answer: 7.91E-82. So does my HP calculator.

These extremely small values are probably beyond the precision of the functions' algorithms.

You can try this but verify your results:-

SetPrecision((-2*Radians(C35)*C36); 82)