AnsweredAssumed Answered

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

Question asked by zibzab_1 on Mar 19, 2010
Latest reply on Mar 19, 2010 by zibzab_1

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.

Outcomes