How To Calculate Percentages in Excel and Google Sheet

  • Post author:
  • Post category:Uncategorized

We can use Excel and Google Sheets to calculate percentage in many ways. In this tutorial, we will discover how to use the basic percentage formula, calculate percentages in Excel and explore different formulas for calculating percentage increase. We will also illustrate the excel percentage formula in multiple cells to calculate the percent increase or decrease.

Figure 1 – Percentage of a number in Excel

General Formula

New Value/Old Value = Percentage

(Old Value – New Value)/Old Value = Percent Change

How to Calculate Percentage Increase or (Change) Between Two Columns

We can quickly calculate the percentage change in our excel sheet across two columns using the steps below:

  • We click on Cell F4 and enter the formula below

=(D4-E4)/D4

Figure 2 – Drawing percentage in excel

  • We will copy down the formula using the fill handle tool (the small box at the lower right corner of the cell) into the number of rows given.

Figure 3 – Calculate percentage in excel

  • We will highlight the Results column
  • We will navigate the Home tab to find the Number group. In this tray, we will click “Percent Style” to display our decimal fractions results as percentages.

Figure 4a – Click on % in Number style

Figure 4b – Excel formula for percentage increase

Calculating the Percentage Increase (Or Decrease) Between Rows

If we wish to calculate percentage within one column of numbers like Column E, we can use these steps:

  • We skip the first cell and click on Cell F5
  • Next, we enter the formula below:

=(E5-E4)/E5

Figure 5 – Percent returned formula excel

  • We will use the fill handle tool to drag down the formula

Figure 6 – Percent change function excel

  • We will highlight the Percentage Change column, go to the Home tab and select “Percent Style” to display results as percentages.

Figure 7 – How to show the percentage change in excel

Calculating Percentage Increase (Or Decrease) to a Reference Cell

We can equally use the Excel percentage change formula to calculate results to a specific cell. Here, we fix the absolute cell as e.g. $E$4 and then:

  • We skip the first cell and Click on Cell F5, and enter the formula below

=(D4-$E$4)/$E$4

  • We use the fill handle tool to drag down the formula.  

Figure 8 – Excel percent change formula

  • We highlight the Result column, go to the Home tab and select “Percent Style” to display results as a percentage.

How to Calculate the Percentage of Grand total

We can see two different events when we wish to achieve Excel percent of the total. This includes:

Total at the end of the table

When we have a Total in a single cell at the end of a Table, we simply take the Single cell as our reference cell and input this formula below. Next, we apply the percent style function

=D4/$D$17

Figure 9 – Excel formula for percentage increase

Parts of Total displayed in different rows

When we have multiple rows with the same value and want to know the part of the total as a percentage, we insert the formula below in Cell F20.

=SUMIF(B4:B16, F19, D4:D16)/($D$17)

Figure 10 – Parts of total derived from the Excel percentage formula

How to Calculate the Total and Amount by a Percentage

When we know the percentage, we can quickly calculate the amount and totals easily in these steps:

Evaluate amount by total and percentage

When we have the Total (Column A) and Percent (Column B), we can quickly learn the Amount by multiplying with the formula below:

=A4*B4

Figure 11 – Excel percentage of the total result

Evaluate total by amount and percentage

We can accuratelyequally find the total when we have the percentage and amount using this formula:

=C4/B4 or =C4/12%

Figure 12 – Getting total from percentage growth in excel

Adding (or subtracting) percentage in Excel

When we wish to increase a number by a percentage in Excel across a column, without updating to a new column, we use the following steps:

  • In Cell F4, we enter the excel formula to add a percentage increase or decrease

=D4 *(1 + 20%) (Increase by percentage) or

=D4*(1 - 20%) (Decrease by percentage)

  • Highlight Cell F4 and press Ctrl + C to copy cell.
  • Next, we highlight the column we wish to increase or reduce
  • We right-click on the selection, and tap, Paste Special
  • Within the Paste Special Dialog Box, we navigate to Paste and mark Values. We also mark Multiply under Operation and select OK to view results increased by 20%

Figure 13 – How to sum percentages in excel

Multiply or Divide a column by a specified percentage

  • In Cell F4, we enter one of the following formulas:

=D4*(1 * 20%) (Multiply by percentage) or

= D4*(1 / 20%) (Divide by percentage)

  • Highlight Cell F4 and press Ctrl + C to copy cell.
  • Next, we highlight the column we wish to increase to increase or reduce
  • We right-click on the selection, and tap, Paste Special
  • Within the Paste Special Dialog Box, we navigate to Paste and mark Values. We also mark Multiply under Operation and select OK to view results increased by 20%

Figure 14- Multiplying excel percent increase

Using the Basic Excel Percentage formula

We use the Excel Percentage formula to calculate the percentage quickly. In the figure below, we have Column D (Ordered groceries) and Column E (Supplied Groceries). Now, we find the percentage of supplied groceries using the steps below:

  • We Click on Cell F4 and enter the formula below

=E4/D4

Figure 15 – Basic Excel Percentage formula

  • Now, we will use the fill handle tool (the small box at the lower right corner of the cell) to drag theour formula into as many rows as we need.
  • Our Results will be displayed as fractions.

Figure 16 – How to show percentage in excel

  • We quickly highlight the Result column.
  • Next, we navigate the Home tab to find the Number group. In this little tray, we click “Percent Style” to display our decimal fractions results as percentages.

Figure 17 – Calculating excel percentages.

Note

We do not have a universal Excel percentage formula. Our approach depends on what we want to achieve. We can also see that 100 should not multiply the Basic Excel Percentage formula since Excel automatically uses the operation once we apply the percent style option from the Number ribbon.