How to Use Formula for Tracking Weight Loss in Excel (2 Examples)

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.

excel formula for tracking weight loss dataset


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%
In this case, cell 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.

calculate weight loss percentage

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

calculate weight loss percentage

  • 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.

calculate weight loss percentage

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.

Computing BMI using Excel Formula

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

Computing BMI using Excel Formula

  • 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

Computing BMI using Excel Formula

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

Computing BMI using Excel Formula

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

computing BMI for tracking weight loss

  • 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.

computing BMI for tracking weight loss

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.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo