# 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. ## 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 ## 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")` The first CONVERT translates feet to meters as follows:

`=CONVERT(B12,"ft","m")/ convert feet to meters` The second translates inches to meters as follows:

`=CONVERT(C12,"in","m")/ converting inches to meters` 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` Finally, we may use the usual BMI formula. In G12, the Formula is:

`=F12/E12^2/ compute BMI` 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)` ## 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")` 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")` 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 ...

Working Time Calculation Based on Timesheets

In the office, a special machine record the time when you start working (clock in office) and when you finish working (clock out of office). We can calculate the total working time by subtracting the end working time from the ...

Sort/Rank Numeric Values with Duplicate Values Exist

Excel built-in RANK function can sort a set of values. If there are duplicate numbers, then the rank number is also duplicated. See the following example: There are two numbers “100” in range A2:A9, they are both the third largest ...

Calculate Days Open in Excel

If you want to know how to Calculate days in Excel, there are some formulas that you can use to do so. For example, you can use the DAYS function in Excel to find the number of days between two ...

Calculate Grades With VLookup in Excel

Why Should You Calculate Grades With VLookup Excel? If you're looking for a simple way to find out a student's grades, VLOOKUP Excel can do the trick. This function uses a lookup table to find the values and sort them ...

Repeating Character n Times in Excel

In daily life, we can use repeated characters to indicate the magnitude or priority of something. For example, a single “!” indicates a minor case, double “!!” indicates a medium case, and triple “!!!” indicates a high case, and so ...

Sidebar