Bmi calculator

Create a BMI calculator in Excel and find out if you are a healthy weight.

Bmi formula excel imperial

Body mass index (BMI) is a measure of body fat based on weight and height that applies to adult men and women. If you're in a hurry, simply download the Excel file.

Below you can find a screenshot of the BMI calculator.

Note: the instructions below do not teach you how to format the worksheet.

We assume that you know how to change font sizes, font styles, insert rows and columns, add borders, change background colors, etc.

To create this BMI calculator, execute the following steps.

1. Create a drop-down list in cell C5.

2.

Insert an IF function into cell D7, D9 and D10 to show the correct units.

3. Select Metric from the drop-down list. The IF function in cell D10 returns an empty string.

Excel bmi formula cm and kg

Bmi spreadsheet

Bmi percentile formula excel

Convert cm to m in excel

Bmi formula excel download

Create a conditional formatting rule that changes the format of cell C10 when you select Metric from the drop-down list (step 6, 7 and 8).

4. Create the BMI formula.

Explanation: C9*12+C10 calculates the height in inches and C9/100 calculates the height in meters.

Using standard

how to calculate bmi in excel

formula to calculate bmi in excel