BMI Calculation Formula In Ms Excel

You might have come across a task in which you were assigned to make BMI calculations of the supplied numbers, and you may be looking for an efficient approach to accomplish this process rather than doing BMI calculations manually, by which you can also complete that task, but ultimately you will end up exhausted.

But don’t worry; we’ve got your back and brought up a most accessible way to perform BMI calculations in a couple of seconds.

So, without further ado, let’s get started.

BMI calculation formula1

What Exactly Is BMI?

Body Mass Index is an abbreviation for Body Mass Index. It is a simple (and affordable) method of determining body fat based on height and weight. BMI is a screening technique that may determine if a person is underweight, overweight, or obese. BMI, on the other hand, is not a diagnostic tool.

General Formula 

The algorithm below may be used to compute BMI calculations.

=weight/height^2

Explanation of Syntax

You must be aware of the Formula’s syntax to use it to complete your task.

  • Division (/): This symbol divides values or integers.

Summary

This tutorial will look at two different ways to compute BMI (Body Mass Index) in Excel. We first convert height and weight to metric units in the example worksheet before calculating BMI using a conventional metric method. In D3, the Formula is:

=C3/B3^2

It delivers an estimated BMI based on a G5 weight and an F5 height

BMI calculation formula1

Explanation

It is easier to grasp the application of the above Formula with the assistance of two examples. The first example demonstrates an effective method for calculating BMI (Body Mass Index) in Excel. The typical BMI formula is as follows:

BMI = weight (kg) / height (m)2

The second method employed here is to first convert height in inches and feet to meters, and weight in pounds to kilograms, before applying the conventional metric calculation for BMI. This allows for collecting size and weight, generally used units (in the United States), and displaying measured quantities utilized in the computation.

The fundamental difficulty, in this case, is that most Americans still use the US conventional measuring system to record height and weight rather than the metric system. As a result, the initial step is to record this data is regularly used units.

Then, in cell E12, we utilize the CONVERT function twice to compute height in meters:

=CONVERT(B12,"ft","m")+CONVERT(C12,"in","m")

BMI calculation formula1

The first CONVERT translates feet to meters as follows:

=CONVERT(B12,"ft","m")/ convert feet to meters

BMI calculation formula1

The second translates inches to meters as follows:

=CONVERT(C12,"in","m")/ converting inches to meters

BMI calculation formula1

The two numbers are then put together to obtain the total height in meters.

In cell F12, we use CONVERT once again to determine the weight in kilograms:

=CONVERT(D12,"lbm","kg")/ converting pounds to kilograms

BMI calculation formula1

Finally, we may use the usual BMI formula. In G12, the Formula is:

=F12/E12^2/ compute BMI

BMI calculation formula1

We utilize Excel’s exponentiation operator, the caret () to square height.

 In addition to the caret (), the POWER function may be used to raise to a power such as this:

=F12/POWER(E12,2)

BMI calculation formula1

Alternatives

The formulae mentioned above can be simplified somewhat. We may use a single CONVERT function to determine the height, as seen below:

=CONVERT(B12*12+C12,"in","m")

BMI calculation formula1

To put it another way, we convert feet to inches immediately within the function parameter. This process occurs before the CONVERT function is called when Excel evaluates the calculation. It’s not as readable, but it’s more compact.

Similarly, we might use CONVERT to convert inches to feet as follows:

=CONVERT(B12+C12/12,"ft","m")

BMI calculation formula1

The end outcome is the same as before. The critical feature is that you may nest additional calculations directly in a function parameter.

Related Posts

Break ties with helper COUNTIF and column

Suppose you got a task to adjust the values that contain the ties; what would be your first attempt to break the ties of the given value? If you are wondering about doing this task manually, let me add that ...

Calculate Total Cost with Excel VLOOKUP Function

In today's article we will show you how to calculate the total cost for a given weight using the Excel VLOOKUP function. This function will help us to find the appropriate unit price for that weight and then we can ...

Excel Formulas To Calculate The Bond Valuation

Assume that you've been assigned a task of calculating bond valuation; so if you are new to Ms Excel or do not have much experience with it, then I am pretty sure about it that doing this task manually might ...

Calculate Cumulative Totals with Excel SUM Function

Today, through a simple example, we will show you how to use one of the most common-used Mathematical functions in excel, the SUM function, to add up the sum. In our daily life, we keep an account of what we ...

Calculate The Period of Loan or Investment in Excel

In our daily life, most of us will invest or take a loan, so we need to master some simple financial functions to calculate the period needed for loans or investments. If you work as an accountant, you need to ...

Sidebar