2 Replies Latest reply on Dec 11, 2017 1:50 PM by Thom Parker

    Need some help using Natural Logarithm/LN Calculation

    Hoey

      I have a couple text boxes as follows:

      text1 = number that doesn't change (6.5459673)

      text2 = number that will change based on input from another text box (box1F6)

       

      in excel the calculation would be: 6.5459673 (or text1) * (LN(F6))

       

      I tried doing this:

      var nBox = + getField("box1F6").value;

       

      event.value = math.log(nBox);

       

      but that didn't even put a 0 or any input for that matter. 

       

      Any help is appreciated! Thanks in advance!