Interest in modern world spinning all over the place. Not a day goes by without using them. When purchasing products, we pay VAT. Having taken out a loan from a bank, we repay the amount with interest. When reconciling income, we also use percentages.
Working with percentages in Excel
Before starting work in Microsoft Excel Let's remember school math lessons where you studied fractions and percentages.
When working with percentages, remember that one percent is a hundredth (1% = 0.01).
When performing the action of adding percentages (for example, 40+10%), we first find 10% of 40, and only then add the base (40).
When working with fractions, do not forget about the basic rules of mathematics:
- Multiplying by 0.5 is equal to dividing by 2.
- Any percentage is expressed as a fraction (25%=1/4; 50%=1/2, etc.).
We count the percentage of the number
To find a percentage of a whole number, divide the desired percentage by the whole number and multiply the result by 100.
Example No. 1. There are 45 units of goods stored in the warehouse. 9 units of goods were sold in a day. How much of the product was sold as a percentage?
9 is a part, 45 is a whole. Substitute the data into the formula:
(9/45)*100=20%
In the program we do the following:
How did this happen? Having set the percentage type of calculation, the program will independently complete the formula for you and put the “%” sign. If we set the formula ourselves (with multiplication by one hundred), then there would be no “%” sign!
Example No. 2. Let's solve the inverse problem. It is known that there are 45 units of goods in the warehouse. It also states that only 20% have been sold. How many total units of the product were sold?
Example No. 3. Let's try the acquired knowledge in practice. We know the price for the product (see picture below) and VAT (18%). You need to find the VAT amount.
We multiply the price of the product by the percentage using the formula B1*18%. 
Advice! Don't forget to extend this formula to the remaining lines. To do this, grab the lower right corner of the cell and lower it to the end. This way we get an answer to several elementary problems at once.
Example No. 4. Inverse problem. We know the amount of VAT for the product and the rate (18%). You need to find the price of a product.
Add and subtract
Let's start with the addition. Let's look at the problem using a simple example:
Now let's try to subtract the percentage from the number. Having knowledge about addition, subtraction will not be difficult at all. Everything will work by replacing one sign “+” with “-”. Working formula will look like this: B1-B1*18% or B1-B1*0.18. 
Now let's find percentage of all sales. To do this, we sum up the quantity of goods sold and use the formula B2/$B$7.
These are the basic tasks we accomplished. Everything seems simple, but many people make mistakes.
Making a chart with percentages
There are several types of charts. Let's look at them separately.
Pie chart
Let's try to create a pie chart. It will display the percentage of sales of goods. First, we are looking for percentages of all sales.
Afterwards, your diagram will appear in the table. If you are not satisfied with its location, then move it by pulling it outside the diagram. 
bar chart
For this we need data. For example, sales data. To create a histogram, we need to select all numerical values (except the total) and select the histogram in the “Insert” tab. To create a histogram, we need to select all numerical values (except the total) and select the histogram in the “Insert” tab. 
Schedule
Instead of a histogram, you can use a graph. For example, a histogram is not suitable for tracking profits. It would be more appropriate to use a graph. A graph is inserted in the same way as a histogram. You need to select a chart in the “Insert” tab. Another one can be superimposed on this graph. For example, a chart with losses. 
This is where we end. Now you know how to rationally use percentages and build charts and graphs in Microsoft Excel. If you have a question that the article did not answer, . We will try to help you.
A percentage is one hundredth of a number taken as a whole. Percentages are used to indicate the relationship of a part to the whole, as well as to compare quantities.
1% = 1 100 = 0,01
The interest calculator allows you to perform the following operations:
Find the percentage of a number
To find the percentage p from a number, you need to multiply this number by a fraction p 100
Let's find 12% of the number 300:
300 12
100
= 300 · 0.12 = 36
12% of 300 is 36.
For example, a product costs 500 rubles and there is a 7% discount on it. Let's find the absolute value of the discount:
500 7
100
= 500 · 0.07 = 35
Thus, the discount is 35 rubles.
What percentage is one number of another?
To calculate the percentage of numbers, you need to divide one number by another and multiply by 100%.
Let's calculate what percentage the number 12 is from the number 30:
12
30
· 100 = 0.4 · 100 = 40%
The number 12 is 40% of the number 30.
For example, a book contains 340 pages. Vasya read 200 pages. Let's calculate what percentage of the entire book Vasya read.
200
340
· 100% = 0.59 · 100 = 59%
Thus, Vasya read 59% of the entire book.
Add percentage to number
To add to a number p percent, you need to multiply this number by (1 + p 100)
Add 30% to the number 200:
200 (1 + 30
100
) = 200 1.3 = 260
200 + 30% equals 260.
For example, a swimming pool subscription costs 1000 rubles. Starting next month they promised to raise the price by 20%. Let's calculate how much a subscription will cost.
1000 (1 + 20
100
) = 1000 1.2 = 1200
Thus, the subscription will cost 1200 rubles.
Subtract the percentage from the number
To subtract from a number p percent, you need to multiply this number by (1 - p 100)
Subtract 30% from the number 200:
200 · (1 - 30
100
) = 200 · 0.7 = 140
200 - 30% equals 140.
For example, a bicycle costs 30,000 rubles. The store gave it a 5% discount. Let's calculate how much the bike will cost taking into account the discount.
30000 · (1 - 5
100
) = 30000 0.95 = 28500
Thus, the bike will cost 28,500 rubles.
What percentage is one number greater than another?
To calculate how many percent one number is greater than another, you need to divide the first number by the second, multiply the result by 100 and subtract 100.
Let's calculate what percentage is the number 20 more number 5:
20
5
· 100 - 100 = 4 · 100 - 100 = 400 - 100 = 300%
The number 20 is 300% greater than the number 5.
For example, the boss’s salary is 50,000 rubles, and the employee’s salary is 30,000 rubles. Let's find out how many percent the boss's salary is greater:
50000
35000
· 100 - 100 = 1.43 * 100 - 100 = 143 - 100 = 43%
Thus, the boss's salary is 43% higher than the employee's salary.
What percentage is one number less than another?
To calculate how many percent one number is less than another, you need to subtract from 100 the ratio of the first number to the second, multiplied by 100.
Let's calculate what percentage is the number 5 less number 20:
100 - 5
20
· 100 = 100 - 0.25 · 100 = 100 - 25 = 75%
The number 5 is 75% less than the number 20.
For example, freelancer Oleg completed orders worth 40,000 rubles in January, and 30,000 rubles in February. Let's find how many percent less Oleg earned in February than in January:
100 - 30000
40000
· 100 = 100 - 0.75 * 100 = 100 - 75 = 25%
Thus, in February Oleg earned 25% less than in January.
Find 100 percent
If the number x This p percent, then you can find 100 percent by multiplying the number x on 100p
Let's find 100% if 25% is 7:
7 · 100
25
= 7 4 = 28
If 25% equals 7, then 100% equals 28.
For example, Katya copies photos from her camera to her computer. In 5 minutes, 20% of the photos were copied. Let's find how long the copying process takes:
5 · 100
20
= 5 5 = 25
We find that the process of copying all photos takes 30 minutes.
In almost every field of activity we are faced with the need to be able to calculate percentages. Most often, we need interest calculation skills when calculating VAT, margin, markup, loan interest, return on deposits and securities, and discounts. All these calculations are made as a percentage of the amount.
Click on the button below to download an Excel file with examples of percentage calculations in Excel:
What is percentage?
Percent (lat. per cent - per hundred) - one hundredth part. Marked with a “%” sign. Denotes a share of something in relation to the whole. For example, 25% of 500 rubles. means 25 parts of 5 rubles. each, that is, 125 rubles.
Basic formula Calculating the percentage of the amount looks like this:
There is no universal formula that fits every interest calculation scenario. Below you will learn about the most popular calculation methods.
How to calculate percentage of amount in Excel
Video lesson:
(Part/Whole) * 100 = Percentage (%)
But if you use the “Percentage” cell format, then to calculate the percentage of a number you just need to divide one number by another. For example, we have apples that we bought for 100 rubles. in a wholesale warehouse, and retail price we will charge 150 rubles. In order to calculate the percentage of the purchase price from the retail price, we need:
- Create a table with prices and add a column to calculate the percentage:
- In cell D2, enter a formula that calculates the percentage of the purchase price from the sales price:
- Apply cell D2 “Percentage” format:
How to calculate the percentage of the sum of values in an Excel table
Video tutorial:
Let's imagine that we have a list of sellers with the sales volume for each and the total amount of all sales for all sellers. Our task is to determine what percentage each seller contributes to the final turnover:
For this we need:
- Add a column to the table with percentage calculation;
- Insert the formula into cell C2:
The $ signs fix column “B” and cell “9” so that when extending the formula to all rows of the table, Excel automatically substitutes the sales volume of each seller and calculates % of total sales. If you do not put the “$” signs, then when you stretch the formula, the system will shift cell B9 as many cells down as you stretch the formula.
- Extend the formula to all table cells corresponding to the rows with the names of the sellers:
- In the example above, we stretched the formula and got the values in the form of fractional numbers. In order to convert the received data into percentages, select the data with the left mouse button and change the cell format to “Percentage”:
How to calculate the percentage of multiple values from the table sum
Video tutorial:
In the example above, we had a list of sellers and their sales volume. We calculated how much each employee contributed to the final sales volume. But what if we have a list of recurring products with sales volume data and we need to calculate what percentage of all sales a particular product represents?
From the list of products above, we want to calculate the sales volume of tomatoes (they are written in several rows of the table). For this:
- To the right of the table we indicate the product (Tomatoes) for which we want to calculate the share in sales:
- Change the format of cell E2 to “Percentage”;
- In cell E2, insert a formula with the function that will help calculate Tomatoes from the list of products and sum up their sales volume, and then divide it by the total sales volume of goods:
How does this formula work?
For calculations we use the formula. This function returns the sum of the numbers specified as arguments that meet the criteria specified in the formula.
The syntax for the SUMIF function is:
=SUMMIF(range, condition, [sum_range])
- range– the range of cells by which the criteria are evaluated. Arguments can be numbers, text, arrays, or references containing numbers;
- condition– criteria that are checked against a specified range of cells and determine which cells to sum;
- sum_range– summed cells. If this argument is not specified, then the function uses the argument range as sum_range .
Thus, in the formula =SUMIF($A$2:$A$8,$E$1,$B$2:$B$8)/B9 we indicated “ $A$2:$A$8” as a range of products among which the function will search for the criterion we need (Tomatoes). Cell “ $E$1” is indicated as a criterion and indicates that we are looking for “Tomatoes”. Cell range “ $B$2:$B$8” indicates which cells need to be summed if the required criterion was found.
How to calculate percentage difference in Excel
For example, to calculate the percentage difference between two numbers A and B, the formula is used:
(B-A)/A = Difference between two numbers as a percentage
In practice, when using this formula, it is important to determine which of the numbers you need is “A” and which is “B”. For example, imagine that yesterday you had 8 apples in stock, and today you have 10 apples. Thus, the number of apples you have compared to yesterday has changed by 25% upward. If you had 10 apples yesterday, and today you have 8 apples, then the number of apples compared to yesterday has decreased by 20%.
Thus, the formula to correctly calculate the percentage change between two numbers looks like this:
(New value - Old value) / Old value = Percentage difference between two numbers
Below, with examples, we will look at how to use this formula for calculations.
The Microsoft Office Excel spreadsheet editor is often needlessly underrated. Many people think that it is difficult to understand, so they use a calculator and other available tools to solve their problems. But why do this if with the help of this editor you can simply recalculate formulas in batches, build graphs, tables almost fully automatically. Yes, and you can master the Excel database in a couple of days. If you want to learn all the functionality of this utility, then visit the website https://tutorexcel.ru/. There you can find any answer to a question regarding Excel.Adding interest
Often, people need to add interest. To avoid doing this manually, just use Excel. And we'll tell you how.Let's assume that to a certain number, you need to add some fixed percentage. To do this, enter our amount in cell A1, from which the percentage will be derived. It will appear in cell A2. But first, let's do the following. As we said above, the percentage in this example is fixed. First, we determine the value of the multiplier. You can’t just enter 25% (our example). To do this, we use the formula 1+(25/100)=1.25. The resulting value is our multiplier, which must be written in cell A2. To do this, click on it and enter the following: equal sign, source cell number (A1), asterisk and multiplier. It looks like this: =A1*1.25. Now all that remains is to confirm the result by pressing the Enter key. The program will give you the result in a matter of seconds.
But it is not always the case that you need to multiply by a fixed percentage. If it changes, then you will have to use three cells.
In the first, as in the previous case, we enter our number. In the second B1 we will enter our percentage. And finally, cell C1 is the result obtained. In order to calculate the percentage, enter the following formula into C1: A1*(1+B1/100). A1 is the original number, and B1 is the percentage. In this case, we write the cell number so that when changing the percentage value, we do not change the formula. She will automatically substitute the number from B1. After that, press Enter and get the finished result.
As you can see, everything is extremely simple and clear. MS Excel is a multifunctional editor that is quite easy to learn, but nevertheless has the best base for working with graphs, tables and formulas.
Excel is used very often due to the ease of creating tables. Most SEO specialists use it to group key queries for their semantic core.
It is most convenient to calculate percentages and perform actions with them in Excel in the Microsoft Office package, since all that is required is to specify the values and the desired formula.
A percentage is a hundredth of a whole number, which is denoted on paper by the % sign or decimals(70% = 0.70). The standard expression for calculating percentage is Whole/Part*100, but thanks to Excel you don’t have to calculate anything manually.
How to calculate percentages in Excel
The simplicity of working with the program lies in the fact that the user only needs to enter the values of the whole and its part (or select from previously entered data), and indicate the calculation principle, and Excel will perform the calculations independently. IN Excel percentage is calculated like this - Part/Whole = Percentage, and multiplication by 100 occurs automatically when the user selects the percentage format:
To carry out the calculations, let’s take the calculation of the execution of the work plan:
The program will independently calculate the percentage of plan completion for each product.
Percentage of number
In Excel, you can calculate a number knowing only its fraction: %*Part = Whole. Let's say you need to calculate what is 7% of 70. To do this:
If the calculation is carried out when working with a table, then instead of entering numbers you need to provide links to required cells. You should be careful; when calculating, the format should be General.
Percentage of the amount
If the data is scattered throughout the table, then you need to use the formula SUMIF- it adds the values that correspond to the specified parameters, in the example - the specified products. The formula for the example will look like this - “=SUMSIF (criterion range; addition range)/total amount”:
In this way, each parameter is calculated, i.e. product.
Calculate percentage change
Comparing two shares is also possible using Excel. To do this, you can simply find the values and subtract them (from the larger to the smaller), or you can use the increase/decrease formula. If you need to compare numbers A and B, then the formula looks like this: (B-A)/A = difference" Let's look at an example of a calculation in Excel:
- Stretch formula to the entire column using the autofill marker.
If the calculated indicators are located in one column for a specific product over a long period of time, then the calculation method will change:
Positive values indicate an increase, and negative values indicate a decrease.
Calculation of value and total amount
Often, it is necessary to determine the total amount knowing only the share. There are two ways to do this in Excel. Consider purchasing a laptop, assuming it costs $950. The seller says that this price does not include VAT, which is 11%. The final markup can be found by making calculations in Excel:
Let's look at the second calculation method using another example. Let’s say that when you buy a laptop for $400, the seller says that the price is calculated taking into account a 30% discount. You can find out the starting price like this:
The starting price will be $571.43.
How to change a value to a percentage value
Often you have to increase or decrease the final number by some fraction of it, for example, you need to increase monthly costs by 20%, 30% and 35%:
The program will calculate the total independently for the entire column if you drag out the expression using the fill marker. The expression for reducing the amount is the same, only with a minus sign - “ =Value*(1-%)».
Operations with interest
You can perform the same operations with fractions as with ordinary numbers: addition, subtraction, multiplication. For example, in Excel you can calculate the difference in indicators between a company's sales using the ABC command, which returns the absolute value of the number:
The difference between the indicators will be 23%.
You can also add (or subtract) a percentage to a number - consider the action using the example of vacation planning:
The program will independently perform calculations and the results will be 26,000 rubles for the vacation week and 14,000 rubles after the vacation, respectively.
Multiplying a number by a fraction in Excel is much easier than manually, since it is enough to indicate the required value and percentage, and the program will calculate everything itself:
All amounts can be quickly recalculated by expanding the formula to cover the entire column F. 
To subtract a share, you must indicate a number in cell A1, and a percentage in cell A2. Perform calculations in cell B1 by entering the formula “ =A1-(A1*A2)». 