Excel Formulas for BMI calculation in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2021-11-02 10:31:28

---
title: Excel Formulas for BMI calculation in Excel Office 365!!
published: true
date: 2021-11-01 11:05:18 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-for-bmi-calculation-in-excel-office-365/
---

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](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.

![](https://geekexcel.com/wp-content/uploads/2021/11/Sample-data-2.png)<figcaption>Sample data</figcaption>

- Then, to calculate BMI, you need to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=G5/F5^2

```

![](https://geekexcel.com/wp-content/uploads/2021/11/Use-the-Formula-2.png)<figcaption>Use the Formula</figcaption>

- Now, you have to **Hit the Enter key** to get the result as given below in the **cell H5**.

![](https://geekexcel.com/wp-content/uploads/2021/11/Result-for-cell-H5-1.png)<figcaption>Result for the cell H5</figcaption>

- Finally, you need to **press Ctrl+D key** to get the result in all columns.

![](https://geekexcel.com/wp-content/uploads/2021/11/Output.png)<figcaption>Output</figcaption>

**Check this too:**

- [Excel Formulas to Find Basic in cell histogram in Excel!!](https://geekexcel.com/excel-formulas-to-find-basic-in-cell-histogram-in-excel/)
- [Formulas to Calculate All dates in chronological order!!](https://geekexcel.com/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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

**Related Articles:**

- **[Excel Calculate Date & Time:Add, Subtract Datetime, Time Difference, Age Calculation](https://geekexcel.com/excel-calculate-date-timeadd-subtract-datetime-time-difference-age-calculation/)**
- **[How to use Excel NETWORKDAYS Function in Office 365?](https://geekexcel.com/how-to-use-networkdays-function-in-ms-excel-365/)**
- **[Fetch Values From Cells for Calculation in Excel Office 365!!](https://geekexcel.com/fetch-values-from-cells-for-calculation-in-excel-office-365/)**
- **[Formulas to Create a Timesheet for Overtime Calculation Formula!!](https://geekexcel.com/excel-formulas-to-create-a-timesheet-for-overtime-calculation-formula/)**
- **[How to use Loan Calculator through Excel Office VBA?](https://geekexcel.com/how-to-use-loan-calculator-through-excel-office-vba/)**