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.
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%
- 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
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
You can download the practice workbook from the link below.
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.
