# Body fat percentage formula

Topic Labels: Formulas
Solved
473 2
cancel
Showing results for
Did you mean:  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: 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?

2 Solutions

Accepted Solutions  16 - Uranus

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``````  4 - Data Explorer

Thank you so much, works perfectly now 🙂

2 Replies 2  16 - Uranus

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``````  4 - Data Explorer

Thank you so much, works perfectly now 🙂 