It is very necessary to track** weight loss** to keep fit and also not become sick. In Microsoft Excel, you can easily keep track of your weight loss and easily see an overview. This article demonstrates two examples of Excel formula for tracking weight loss.

## Download Practice Workbook

You can download the practice workbook from the link below.

## 2 Examples with Excel Formula for Tracking Different Weight Loss Parameters

You can easily calculate the parameters for tracking weight loss using Excel. Now, let’s assume a dataset where you have the *Starting Weight, Goal, Start Date, End Date, Height, Weight loss per week, Gender, *and *Weight Loss Tracker *for a month. At this point, you want to calculate different parameters which will help you to track weight loss. In this case, we will show you the steps to calculate two parameters for tracking weight loss.

### 1. Calculate Weight Loss Percentage Using Excel Formula

**Weight Loss Percentage** is one of the most important parameters to track weight loss. Right now, follow the steps below to calculate the weight loss percentage per week and overall weight loss percentage in a month.

__Steps__**:**

- First, add a new column for
*Weight Loss Percentage*in the*Weight Loss Tracker*. - Next, select cell
**E11**and insert the following formula.

`=(C11-D11)/C11%`

**E11**is the first cell for the column

*Weight Loss Percentage*. Also, cells

**C11**and

**D11**are the first cells of the column

*Previous Weight (lb)*and

*Current Weight*

*(lb)*respectively.

- Now, drag the
**Fill Handle**to the rest of the cells of the remaining column.

- At this point, select cell
**G6**and insert the following formula to calculate the**Overall Weight Loss Percentage**.

`=(C4-OFFSET(D11,COUNT(D11:D14)-1,0))/C4%`

In this case, cell **G6 **is the cell indicating the *Overall Weight Loss Percentage*.

Also, we used the **OFFSET Function** to insert the last value of the *Current Weight (lb) *column. Moreover, we used the **COUNT Function** to find out the total number of rows in the *Current Weight (lb)* column.

So, the final output will be as follows.

*Note: **We have skipped the other **4 effective methods to calculate the Weight Loss Percentage**.*

**Read More:** **How to Calculate Weight Gain or Loss in Excel (5 Easy Methods)**

### 2. Compute BMI and Color Code Applying Excel Formula

**BMI** or the *Body Mass Index* is another important parameter to keep your weight loss in check. Now, if you want to calculate *BMI* and *Color Code *the cell according to the BMI chart for a male of 22 years with a height of 178.18 cm, you can follow the steps below.

__Steps__**:**

- First, select the cell you want to keep the
*BMI*In this case, it is cell**.****G9**. - Then, from the
**Home**tab go to**Conditional Formatting**>**Manage Rules**.

- Next, select
**Current Selection**from the**Show formatting rules for**. - After that, click on
**New Rule**.

- Now, select
**Format only cells that contain**. - Then, from
**Format only cells with**select**Cell Value**>**less than**and add**5**to add the first condition. - At this point, click on the
**Format**

- Consequently, select the
**Fill** - Then, select the color for this condition. In this case, it is
**Yellow**. - After that, click on
**OK**.

- Similarly, add the conditions and color code to them.
- After adding all the conditions, click on
**OK**.

- Finally, select cell
**G9**and insert the following formula.

`=ROUND(CONVERT(OFFSET(D11,COUNT(D11:D14)-1,0),"lbm","kg")/(CONVERT(C6,"cm","m"))^2,1)`

In this case, we use the **CONVERT**, **OFFSET**, **COUNT**, and **ROUND** functions for the following purposes:

**CONVERT Function:**To convert*lb*to*kg*and to convert*cm*to*m*.**OFFSET Function:**To insert the final value of the*Current Weight (lb)*column.**COUNT Function :**To calculate the number of rows in the*Current Weight (lb)*column.**ROUND Function:**To round the*BMI*value to one decimal place.

After using the above formula, you’ll get the following output.

**Read More:** **How to Create a Body Mass Index (BMI) Calculator in Excel Using VBA**

## Conclusion

In this article, I have shown you two examples to calculate two different parameters for tracking weight loss and also provided a template. So, you can download the **Template **and utilize it if you want. Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please leave a comment below. Also, if you want to read more articles like this, you can visit our website **ExcelDemy**.