Skip to main content

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?

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

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 🙂 

Reply


Terms & Conditions