Apr 02, 2023 11:12 PM - edited Apr 03, 2023 12:04 AM
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?
Solved! Go to Solution.
Apr 03, 2023 01:47 AM
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
Apr 03, 2023 06:14 AM
Apr 03, 2023 01:47 AM
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
Apr 03, 2023 06:14 AM
Thank you so much, works perfectly now 🙂