Help

Body fat percentage formula

Topic Labels: Formulas
Solved
Jump to Solution
1455 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Marylene_Brunel
4 - Data Explorer
4 - Data Explorer

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:
Screenshot 2023-04-03 at 10.00.12 AM.png

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

 

 

 

Screenshot 2023-04-03 at 11.03.16 AM.png

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?

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

See Solution in Thread

Thank you so much, works perfectly now 🙂 

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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 🙂