How to Calculate Weight Loss Percentages in ExcelLast Updated: May 26, 2015 | By James Highland
Microsoft Excel is spreadsheet software for organizing or calculating data of any kind. You can use Excel for many purposes as it is easy to create a formula-based spreadsheet that manipulates numbers for a clear result. If you wish to calculate weight loss percentages in Excel, this is easy to do and can be set up in a few minutes. This basic use of the program is also a suitable way to learn how to use Excel so you can develop more complex applications to
track your fitness progress if desired.
Click in cell A3. Type "Weight Loss Percentage:" and press "Enter."
Click in cell B3. Type an equal sign ("=") followed by the formula "(B1-B2)/B1" and press "Enter." Note, you should not include the quotes when you type the formula.
Click the "File" menu and choose the "Save" command to save your work to a new file. As this is a new spreadsheet, you will see a pop-up window requesting the name of the file and the disk location for storage. Enter the information and press the "Save" button to complete the save process.Source: www.livestrong.com