Step 3 Enter the formula B2-B1B1100 and Excel will display the gain or loss expressed as a percentage. Weight loss percentage weight loss previous weight x 100. Excel formula for percentage change percentage increase decrease To calculate percent change between values A and B use the following formula.
Using the Excel Weight Loss Chart Template.
As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula. Percent Change B - A A When applying this formula to real data it is important that you correctly determine which value is A and which is B. Weight loss percentage weight loss previous weight x 100. The basic formula for calculating a percentage is parttotal.