Have you ever tried to use a BMI calculation Formula in Excel? How could you calculate them quickly? Here we will show the simple formulas to use a BMI calculation Formula in Excel Office 365. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- If you want to use a BMI calculation Formula, use the below-mentioned formula.
=weight/height^2
Syntax Explanation
- Division (/) – It is used for dividing values or numbers.
Practical Example
Use the following steps for BMI calculation Formula in Excel.
- In the following example, you have to create sample data in Microsoft Excel.
- Then, to calculate BMI, you need to use the below given formula in the formula bar.
=G5/F5^2
- Now, you have to Hit the Enter key to get the result as given below in the cell H5.
- Finally, you need to press Ctrl+D key to get the result in all columns.
Check this too:
- Excel Formulas to Find Basic in cell histogram in Excel!!
- Formulas to Calculate All dates in chronological order!!
Wrap-Up
In this article, we have discussed how to discuss the formulas to use a BMI calculation Formula in Excel Office 365. Hope that this article is useful to you. Leave a comment or reply below to let me know what you think!
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Related Articles:
- Excel Calculate Date & Time:Add, Subtract Datetime, Time Difference, Age Calculation
- How to use Excel NETWORKDAYS Function in Office 365?
- Fetch Values From Cells for Calculation in Excel Office 365!!
- Formulas to Create a Timesheet for Overtime Calculation Formula!!
- How to use Loan Calculator through Excel Office VBA?
Top comments (0)