BMI Calculations in Google Sheets
We use Google Sheets to make the following calculations to determine the user’s body mass index (BMI).
Age of the respondent
The user’s DOB is a mandatory field on the form. The DATEDIF function tells us the age the person is in years.
=MAP(C:C, LAMBDA(c, IF(ROW(c)=1, “Age”,
IF(ISDATE(c), ROUND(DATEDIF(c, TODAY(), “Y”), 0),))))
BMI Score (kg/m²)
Users are asked to input their height and weight on the form. Every response on the form has its BMI calculated using the MAP function.
=MAP(E:E,F:F, LAMBDA(ht, wt, IF(ROW(wt)=1, “BMI”,
IF(AND(ISNUMBER(wt),ISNUMBER(ht)),
ROUND(wt/(ht/100)^2,2),))))
BMI Category
We use the array function to determine the BMI category.
=ARRAYFORMULA(IF(ROW(J:J)=1, “BMI Category”, IF(ISNUMBER(J:J),
IF(J:J < 18.5, “Underweight”,
IF(J:J < 25, “Normal weight”,
IF(J:J < 30, “Overweight”, “Obese”))),)))
Create a BMI Calculator using Google Forms and Google Sheets
How to Create BMI Calculator in Google Forms
- What is BMI?
- How to Create a Google Form for BMI Calculation
- Creating a Google Form for BMI Calculation
- Establishing the BMI calculator
- BMI Calculations in Google Sheets
- Conclusion
- FAQS on BMI Calculator
Tired of those confusing weight charts and old-fashioned BMI calculators? Want a quick and easy way to see your Body Mass Index (BMI) on your phone? We got you covered!
This trick uses Google Forms and Sheets to create a super simple BMI calculator. No fancy machines or confusing numbers – just a quick form, a few taps, and there you have it – your personal BMI!
Ready to ditch the mystery and check your BMI in a fun new way? Let’s get started!
Contact Us