contador web Saltar al contenido

How to calculate percentage increase in Excel | Productivity

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

How to delete all blank lines in Excel at once

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

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 LoubakCreate a column for percentage increase Photo: Reproduction / Ana Letcia Loubak

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 LoubakApply the indicated formula to calculate the percentage increase. Photo: Reproduction / Ana Letcia Loubak

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 LoubakClick on the "%" button to display the value in percent format. Photo: Reproduction / Ana Letcia Loubak

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 LoubakExcel display percentage increase Photo: Reproduction / Ana Letcia Loubak

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 LoubakCalculate the increase of a value by a specific percentage. Photo: Reproduction / Ana Letcia Loubak

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 LoubakExcel indicate new value Photo: Reproduction / Ana Letcia Loubak

Excel indicate new value Photo: Reproduction / Ana Letcia Loubak