How to Calculate the Percent of Loss/Gain in Microsoft Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Percent change is used to measure investment performance.

The percent gain or loss is used to compare changes over time of different scales. By using percentages rather than raw numbers, you can accurately compare different sizes, such as an investment of $100 and an investment of $10,000. Though you could calculate the percent change with a calculator, using a spreadsheet program, such as Microsoft Excel, allows you to change the numbers that you use to quickly see how the percent change would be altered.

Advertisement

Step 1

Label cell A1 "Original Value," cell A2 "Final Value" and cell A3 "Percent Change."

Video of the Day

Step 2

Enter the original value in cell B1 and the final value in cell B2. For example, if the original value equals 71 and the final value equals 80, you would enter 71 in B1 and 80 in B2.

Advertisement

Step 3

Enter the formula "(B2-B1)/B1*100" and Excel will display the gain or loss expressed as a percentage. In the example, when you enter the formula, Excel displays "12.67605634" meaning you have a 12.67 percent increase.

Advertisement

Video of the Day

Advertisement

Advertisement

references