Excel allows you to calculate percentage increases quickly and practically. By applying simple formulas, Microsoft's spreadsheet editor eliminates the need to use a calculator or other program to get the result. The program also has a specific format for data of the type, preventing the user from having to multiply the result by 100 and manually enter the percentage symbol (%). This is a useful tip for salespeople, tracking monthly expenses, or clearing statistical data, for example. Check out the following tutorial how to calculate percentage increase in Excel.
How to add data to Excel from a photo
How to delete all blank lines in Excel at once
Want to buy a cell phone, TV and other discounted products? Meet the Compare dnetc
Percentage increase calculation
Step 1. To start, I need to create two columns with the values ​​that will be compared, plus a column to display the result of the calculation. In this example, we want to find the percentage increase in monthly spending from September compared to August;
Create a column for percentage increase Photo: Reproduction / Ana Letcia Loubak
Step 2. To calculate the percentage difference, we subtract the value of this month from the last month and then divide the result by the value of the last month. Click the "Increase%" column and type the following formula: "= (B3-A3) / A3" (without quotation marks);
Apply the indicated formula to calculate the percentage increase. Photo: Reproduction / Ana Letcia Loubak
Step 3. Excel will display the result of the calculation. To display the value as a percentage, tick the "Percent Style" icon;
Click on the "%" button to display the value in percent format. Photo: Reproduction / Ana Letcia Loubak
Step 4. In this case we will see that the increase in spending was 72%.
Excel display percentage increase Photo: Reproduction / Ana Letcia Loubak
Increase value by a specific percentage
Step 1. In this example, we want to increase the price of a product by 30%. To do this we must click on the cell with the old price and multiply it by 1.3. Just follow the formula "= A3 * 1,3" (without quotes);
Calculate the increase of a value by a specific percentage. Photo: Reproduction / Ana Letcia Loubak
Step 2. Excel show the result.
Excel indicate new value Photo: Reproduction / Ana Letcia Loubak