Body fat percentage formula

Question

Can someone smarter than me help me creating this formula 🙂
I'm trying to create a body fat calculator formula based on waist (cm) , hip (cm) and neck (cm)
The calculation I'm trying to make as a formula (for women) is this one:

And this is what I came up with in Airtable, but it says: Invalid formula:

495/(1.29579−0.35004*LOG({Waist (cm)}+{Hips (cm)}-{Neck (cm)})+0.22100*LOG(180))-450

For now I just want to test it and use it for myself, so I've plug in my height directly in the formula which is 180cm.
In my table I have a field for each measurements.

What am I doing wrong and how can I make it work?

Best answer by TheTimeSavingCo

Your formula's fine actually, it's just that one of your dashes is...weird? I replaced the dash here:

1.29579−0.35004

And now it works fine

Here's the working formula:

495 /
(
  1.29579 -
  0.35004 * 
  LOG(
    (
      {Waist (cm)} + 
      {Hips (cm)} - 
      {Neck (cm)}
    )
  ) + 
  0.22100 * 
  LOG(
    180
  )
) - 
450

TheTimeSavingCo · Accepted Answer

Your formula's fine actually, it's just that one of your dashes is...weird? I replaced the dash here:

1.29579−0.35004

And now it works fine

Here's the working formula:

495 /
(
  1.29579 -
  0.35004 * 
  LOG(
    (
      {Waist (cm)} + 
      {Hips (cm)} - 
      {Neck (cm)}
    )
  ) + 
  0.22100 * 
  LOG(
    180
  )
) - 
450

Thank you so much, works perfectly now 🙂

Marylene_Brunel · Answer

Your formula's fine actually, it's just that one of your dashes is...weird? I replaced the dash here:

1.29579−0.35004

And now it works fine

Here's the working formula:

495 /
(
  1.29579 -
  0.35004 * 
  LOG(
    (
      {Waist (cm)} + 
      {Hips (cm)} - 
      {Neck (cm)}
    )
  ) + 
  0.22100 * 
  LOG(
    180
  )
) - 
450

Thank you so much, works perfectly now 🙂

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded