Users use Excel as a tool to track certain things such as **Costing**, **Weight Loss**, etc. Using a worksheet to calculate weight loss percentage in Excel is common nowadays. Typical **Arithmetic** **Formula**, other **Excel Functions** to fetch the most recent or minimum value to calculate weight loss percentage in Excel.

Let’s say we have weight data intervals every **15** consecutive dates. And we want to calculate the weight loss percentage for each consecutive date or overall period of time.

In this article, we demonstrate cases to bring desired value (that can be minimum or lookup) to calculate weight loss percentage in Excel.

**Table of Contents**hide

**Download Excel Workbook**

**5 Easy Ways to Calculate Weight Loss Percentage in Excel**

Before commencing the calculation, set the cell format in **Percentage**. As a result, Excel automatically displays the **Percentage** rather than fractions whenever the percentage is calculated. To do so, highlight the cells, then, Go to **Home** > Select **Percentage** (from the **Number** section).

Keep the calculated values in **Percentage** format to display the percentage in resultant values. Follow the latter cases to calculate weight loss percentage in Excel.

**Method 1: Calculate Weight Loss Percentage Using Arithmetic Formula**

A typical **Arithmetic Formula** can calculate the weight loss percentage. Subtracting the subsequent weight and then dividing by the initial weight results in a weight loss percentage.

**Step 1:** Paste the below typical formula in any cell (i.e., **D6**).

`=(C6-$C$5)/ABS($C$5)*-1`

** **In the formula, the **ABS** function passes the absolute value of any number.

**Step 2:** As the cells are previously formatted in **Percentage**, Hit **ENTER** then, drag the **Fill Handle** to display all the weight loss percentages for each **15** days interval.

**Read More:** **Percentage Formula in Excel (6 Examples)**

**Method 2: Assign Minimum Value Using MIN Function in Percentage Calculation**

Sometimes, we want to find the overall weight loss based on spread-weight data over months. In that case, we need to find the minimum weight within a range to deduct from the starting weight. Excel’s **MIN** function does the job.

**Step 1:** Use the following formula in any blank cell (i.e., **E5**).

`=(C5-MIN(C5:C15))/C5`

The **MIN** function just fetches the minimum weight within the range (**C5:C15**).

**Step 2:** Press **ENTER** to display the weight loss percentage in **E5**.

If you don’t pre-format the cells in **Percentage**, Excel merely shows the decimals as weight loss percentage.

**Read More:** **How do you Calculate Percentage Increase or Decrease in Excel**

**Method 3: Using LOOKUP Function to Bring Last Value in Percentage Calculation**

Similar to **Method 2**, we can use the **LOOKUP** function to auto-find the last weight from the range.

**Step 1:** Type the below formula in any cell (i.e., **E5**).

`=(C5 - LOOKUP(1,1/(C5:C15<>""),C5:C15))/C5`

Inside the **LOOKUP** function **1** is the **lookup_value**, **1/(C5:C15<>””) **is the** lookup_vector**,** C5:C15 **is the** result_vector**.

**Step 2:** To apply the formula use the **ENTER** key and Excel returns the overall weight loss percentage.

**Read More:** **How to Calculate Percentage of a Number in Excel (5 Easy Ways)**

**Similar Readings**

**How to Apply Percentage Formula in Excel for Marksheet (7 Applications)****How to Calculate Bacterial Growth Rate in Excel (2 Easy Ways)****Calculate Average Percentage in Excel [Free Template+ Calculator]****How to Calculate Net Profit Margin Percentage in Excel****Percentage Difference between Two Percentages Excel (2 Easy Ways)**

**Method 4: Pass Most Recent Value Using OFFSET-COUNT**

In some cases, users have tens of weight data and it’s hard to get around with it. We can use the **OFFSET** function to assign row and column numbers from where Excel gets the latest weight value to subtract. The syntax of the **OFFSET** function is

`OFFSET (reference, rows, cols, [height], [width])`

The arguments define

**reference**; starting (provided as **cell** or **range**), to count rows or columns from.

**rows**; number of rows below from the **reference**.

**cols**; number of columns right of the **reference**.

**height**; number of the rows to return. **[Optional]**

**width**; number of columns to return. **[Optional]**

**Step 1:** Write the following formula in any desired cell.

`=(C5-OFFSET(C5,0,COUNT(C5:K5)-1))/$C$5`

Comparing the formula to syntax, **C5 **is** reference**, **0 **is** rows, COUNT(C5:K5)-1 **is** cols**. The **OFFSET** portion of the formula fetches the rightmost weight value to deduct from the initial one.

**Step 2:** After pressing **ENTER**, you’ll get the overall percentage weight loss considering the rightmost value as the latest weight value.

The **OFFSET** formula is specially used for horizontally inputted entries. You can use the typical **Arithmetic Formula** in this case. However, it’s become inefficient to use the **Arithmetic Formula** in the Method of a huge dataset.

**Read More:** **Excel formula to calculate percentage of grand total (4 Easy Ways)**

**Method 5: Calculate Weight Loss Percentage Using INDEX-COUNT to Fetch Last Value **

What we did with the **OFFSET** function in the previous case, we can do the similar thing with the **INDEX** function. We can use the **INDEX** function to insert the last row value from the given range.

**Step 1:** Insert the following formula in any cell.

`=(INDEX(C5:C15,COUNT(C5:C15),1)-C5)/C5`

The **INDEX** portion of the formula declares **C5:C15** as an **array**, **COUNT(C5:C15)** as **row_num**, and **1** as **column_num**. The **COUNT** function passes the **row_num** of the given **range** (i.e., **C5:C15**).

**Step 2:** Using the **ENTER** key insert the formula. Afterward, Excel displays the overall weight loss percentage with a minus (**–**) sign. The minus sign indicates the lessened amount in weight occurred over the observed period of time.

**Read More:** **How to Calculate Win-Loss Percentage in Excel (with Easy Steps)**

**Conclusion**

In this article, we demonstrate multiple formulas to calculate weight loss percentage in Excel. All the formulas are capable, but you can use any one of them according to your data type. Comment, if you have further inquiries or have anything to add.

**Related Articles**

**How to Calculate Forecast Accuracy Percentage in Excel (4 Easy Methods)****How to Calculate Minus Percentage in Excel (2 Methods)****Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Profit Percentage in Excel (3 Methods)****Calculate Annual Growth Rate in Excel (3 Methods)****How to Calculate Revenue Growth Rate in Excel (3 Methods)**