Need help with a calculation for body fat measurement

  • Profile Image
    mbewley
    Asked on October 12, 2017 at 12:27 PM

    I've written this Navy Circumference Formula exactly as its written in Excel and can't get it to work/calculate properly in JotForm. I need assistance with correcting this formula -- what am I missing/doing wrong?

  • Profile Image
    Kiran
    Answered on October 12, 2017 at 02:02 PM

    I see that the form is showing some calculated result as I enter some values to it. However, I am not sure if it is calculating correctly. If you can provide us with the formula that you are working on, we can take a look and examine the form calculation.

    We will wait for your response. Thank you! 

  • Profile Image
    EltonCris
    Answered on October 12, 2017 at 03:38 PM

    That's one pretty complex calculation. :)

    Anyway, my suggestion is to break down the formula. This is to ensure that you are getting the right number on every calculation.

    Example:

    1. First calculation field gets the %Fat value

    2. Second calculation gets the log(abdomen-neck)

    3. Third gets the log(height)

    And then on your final calculation, you simply use the value on each of these fields and then calculation them. This at least simplifies the calculation process and probably gives a finer result. 

    Please try it and let us know if we can be of further help.