Establishing the BMI calculator
Step 7: Select an empty column for BMI calculation in the sheet
Select any blank column in the Google Sheets to calculate the BMI for each form submission.
Step 8: Name the selected column
Give a suitable title to the selected column.
Step 9: Enter the formula in the first row
In the very first row, where the patient entries are filled, enter the BMI formula to calculate each patient’s BMI.
In this case, Row 2 is the first line of data, G is the weight column, and H is the height column.
Type in the formula: =G2/(H2)^2*703.
Note:
- For the U.S. imperial measurement system, the formula for BMI is weight / [height]2 x 703.
- Drag the mouse’s cursor to the data rows to apply the formula to all the cells.
- Once you have this formula, you can quickly find each new patient’s baseline body mass index (BMI) to use as a reference during your evaluations.
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