**mbewley**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?

- JotForm Support
**Kiran**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!

- JotForm Support
**EltonCris**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*value2. 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.

**mbewley**Thanks for everyone’s assistance. I tried your suggestion Elton Cris but your suggestion didn't seem to work. In fact, the problem appears to be with the log equation — it simply doesn’t work.

Suggestions welcomed.

Regards,

Bewley

...- JotForm Support
**Kiran**Could you share the form URL that you have already worked with Elton's suggestion so that we may be able to fix it? Also, if you can provide us the Excel sheet with the formula we can check that might help us. You may email the Excel sheet to support@jotform.com with the subject title "Support forum - 1271671".

Thanks!

**mbewley**Thanks for your help Kiran. I already scraped the "Elton's" form since it didn't work. I've included all the excel formulas in this thread but will upload the excel sheet per your instructions.

A simple test for the JotForm log function is create a field and enter a value. Next, create a calculating field with log function and no calculations happen in JotForm. I do the same in Excel and it works, which led me to state in my previous post the log JotForm function doesn't work.

Your assistance is greatly appreciated.

- JotForm Support
**Kiran**Thank you for sharing the spreadsheet with us. Please allow me some time to work on the form and see if I can get you something. I'll update you here once I have any news in this regard.

Thank you!

**mbewley**Thank you very much, Kiran for your time and willingness to assist. Greatly appreciated!!!

- JotForm Support
**Kiran**Thank you for your patience. As I tried to create the form to use the same formula, I notice that the log() value is being calculated incorrectly which is why the calculation is failing on the form.

Here is the form that I was trying to create: https://form.jotform.com/72983631607968

I am forwarding the issue to our backend team to take a look at it. Once we have any update from them, I'll update the form and let you know here.

Thank you!

**mbewley**I knew I wasn't crazy when I said the log() function didn't seem to work ;-)

Thank you, Kiran for your all your time and assistance -- much appreciated!!!

Regards,

Mike