Table of Contents:
Calculating percentages in Excel: a step-by-step guide
Why is this necessary? It is often necessary to determine how one number relates to another as a percentage. For example, when analyzing car dealership sales, it is important to understand what percentage of total sales is made up of the individual results of managers. This will help in assessing the performance of each employee.
How to calculate? First, you need to select the cells in which the results will be displayed. Then, you need to change the format of these cells from total to percentage. You can do this in one of three ways:
1. Right-click on the selected cells and select "Format Cells."
In the window that opens, select "Percentage" and specify the number of decimal places. For example, to round to whole numbers, set 0, for decimals – 1, for hundredths – 2, and so on. Click OK.
2. On the Home tab, click the arrow next to the format field and select Percentage format.
3. Click the "%" button on the main toolbar.
Now, to calculate the percentage for the first manager, click on the cell next to his name and enter the formula: fx=D22/D21.
Here, D22 is the sum of the first manager's sales, and D21 is the total sum of the dealership's sales for the same period.
In Excel, the result is automatically displayed as a percentage, without the need to multiply it by 100. This is achieved through cell formatting.
Similarly, for the second manager, use the formula: fx=D23/D21.
This way, you can easily determine that the first manager's sales in March are 10% higher than the second. This data is useful for analyzing performance and making management decisions.
How to add or subtract a percentage in Excel
When you need to adjust a value based on a percentage, Excel provides simple tools for such calculations. For example, this may be relevant for analyzing car prices with a 10% change.
Using Excel, you can quickly calculate how the price of a car will change after an increase or decrease by a given percentage. This is especially relevant in business and finance.
Select the first cell in the column where you want the result. Write the formula: fx=D2+D2*E2. Here D2 is the original price, and E2 is the percentage change.
After running the formula, you will receive a new value for the car price, for example, with an increase of 10%.
To apply the calculation to all other cars, drag the formula down — Excel will adapt it to other values.
To determine how car prices will change after a 10% decrease, change the formula to: fx=D2–D2*E2.
How to calculate the percentage change in values in Excel
You may need to calculate the percentage change in a metric, for example, in financial reporting or when analyzing product prices.
Let's say you have new car prices and you need to figure out how much they differ from previous values.
How to perform the calculation? Select the first cell in the column where you want to place the results and enter the formula: fx=(E2–D2)/D2. Here E2 denotes the new price and D2 denotes the old price. This is the standard way to calculate percentage change, allowing you to quickly get the data you need.
To avoid multiplying the result by 100%, change the format of the cell containing the result to "Percentage."
After entering the formula, you will get the percentage change for the first car. To extend the result to the remaining rows, drag the formula down the column.
How to calculate a number as a percentage of a given value
This approach should be used in cases where you want to know what percentage of a certain amount the desired number is.
For example, you want to determine how much the down payment for a car will be if you know it is 20% of the total cost. This is necessary when planning a budget for the purchase.
First, select the cell in the table where you want to display the result. Then enter the formula: fx=D2*E2. In this formula, D2 represents the price of the car, and E2 is the percentage of the prepayment.
After entering the formula, you will receive the prepayment amount for the first car. To calculate for other cars, simply drag the formula down the column.
This way, you can quickly and accurately determine what the desired percentage of a given amount is.
How can I do similar calculations in Google Sheets? Use all the methods described above. They are fully compatible with Excel functionality. To change the cell format to percentage, simply click the button on the toolbar.
Excel and Google Sheets: from beginner to PRO in 30 days
Want to automate your work with spreadsheets? A training course for quickly mastering Excel and Google Sheets. Practice your skills using real-life examples from everyday life and work.
Learn more