12 Replies Latest reply on Mar 19, 2010 11:58 PM by zibzab_1

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

    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.