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. 
Histogram
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.
In this article I will tell you about a very simple and common task in Excel - how to add percentages in excel using formula.
Mathematical way to add percentages to a number
Although all computer programs are developed for people to make their work easier, this does not mean that you do not need to know mathematics. So let's remember a little mathematics, how to do this on a piece of paper. For example, we need to add 5%. To do this, we must first find 5% of the number, and therefore add the resulting 5% to the known number. The simplest way finding 5% is solving the proportion:
Theory - the basic proportion for finding the desired percentage
After finding X, the number is added with the resulting value. I would like to immediately note that for many, such a method will turn out to be an insurmountable pitfall. In the end it looks like this:
Theory is the result of finding the desired percentage
Having mastered the routine theory of mathematics, you can move on to solving the problem in Excel.
Adding percentages to a number in excel
Suppose we need to add 5% to the number 37. To do this, we will write the number 37 in cell B2, and in cell C2 we will write the formula we know:
After we press "enter" we may get the "wrong" result.
Obtaining such a result is due to the fact that the computer incorrectly determined the cell format. Therefore, to obtain reliable data, you need to specify the cell format with the “numeric” formula.
Applying percentage addition to a number
The described task occurs very often. For example, in economics, you need to add 3% to wages brigade workers.
As can be seen from the figure, cell D9 contains the formula known to us. Press “enter” and change the cell format to “Numeric” (if necessary). After this, we will extend the formula to the remaining cells in the column. As a result, we will get the following result.
The previous methods of adding percentages in Excel can be called “clumsy” and are used more often by those who have little practice with the application. This is due to the fact that there is The recommended way to add percentages is to use the percentage symbol (%).
Let's say we have a small tablet, in the first column we have a number written, and in the second, how many percentages need to be added. We will write the result in the third column.
In the third column we need to write the formula H3+H3*I3%, please note that we multiply cell H3 by cell I3%. I hope everyone saw the percentage symbol.
Essentially this method no different from what was described earlier. The developers just thought that it would be intuitive.
During calculations, sometimes you need to add percentages to a specific number. For example, to find out the current profit indicators, which have increased by a certain percentage compared to the last month, you need to add this percentage to the profit of the previous month. There are many other examples where you need to perform a similar action. Let's figure out how to add a percentage to a number in Microsoft Excel.
So, if you just need to find out what a number will be equal to after adding a certain percentage to it, then you should enter an expression using the following template in any cell of the sheet, or in the formula bar: “=(number)+(number)*(percentage_value )%".
Let's say we need to calculate what number we get if we add twenty percent to 140. Write the following formula in any cell, or in the formula bar: “=140+140*20%”.
Applying a formula to actions in a table
Now, let's figure out how to add a certain percentage to the data that is already in the table.
First of all, select the cell where the result will be displayed. We put a “=” sign in it. Next, click on the cell containing the data to which the percentage should be added. We put the “+” sign. Again, click on the cell containing the number and put the “*” sign. Next, we type on the keyboard the percentage by which the number should be increased. Don’t forget to put the “%” sign after entering this value.
Click on the ENTER button on the keyboard, after which the calculation result will be shown.
If you want to extend this formula to all the values of a column in the table, then simply stand on the lower right edge of the cell where the result is displayed. The cursor should turn into a cross. Click on the left mouse button, and with the button held down, “stretch” the formula down to the very end of the table.
As you can see, the result of multiplying numbers by a certain percentage is also displayed for other cells in the column.
We found that adding a percentage to a number in Microsoft Excel is not that difficult. However, many users do not know how to do this and make mistakes. For example, the most common mistake is to write a formula using the algorithm “=(number)+(percent_value)%” instead of “=(number)+(number)*(percentage_value)%”. This guide should help you avoid such mistakes.
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.
Using a percentage calculator you can make all kinds of calculations using percentages. Rounds results to the required number of decimal places.
What percentage is number X of number Y. What number is X percent of number Y. Adding or subtracting percentages from a number.
Interest calculator
clear formHow much is % of number
Calculation0% of number 0 = 0
Interest calculator
clear formWhat % is the number from the number
CalculationNumber 15 from number 3000 = 0.5%
Interest calculator
clear formAdd % to number
CalculationAdd 0% to the number 0 = 0
Interest calculator
clear formSubtract % of the number
Calculation to clear everythingThe calculator is designed specifically for calculating interest. Allows you to perform a variety of calculations when working with percentages. Functionally it consists of 4 different calculators. See examples of calculations on the interest calculator below.
In mathematics, a percentage is one hundredth of a number. For example, 5% of 100 is 5.
This calculator will allow you to accurately calculate the percentage of a given number. There are various calculation modes available. You will be able to make various calculations using percentages.
- The first calculator is needed when you want to calculate the percentage of the amount. Those. Do you know the meaning of percentage and amount?
- The second one is if you need to calculate what percentage X is of Y. X and Y are numbers, and you are looking for the percentage of the first in the second
- The third mode is adding a percentage of the specified number to given number. For example, Vasya has 50 apples. Misha brought Vasya another 20% of the apples. How many apples does Vasya have?
- The fourth calculator is the opposite of the third. Vasya has 50 apples, and Misha took 30% of the apples. How many apples does Vasya have left?
Frequent tasks
Task 1. An individual entrepreneur receives 100 thousand rubles every month. He works in a simplified manner and pays taxes of 6% per month. How much taxes does an individual entrepreneur have to pay per month?Solution: We use the first calculator. Enter the bet 6 in the first field, 100000 in the second
We receive 6,000 rubles. - tax amount.
Problem 2. Misha has 30 apples. He gave 6 to Katya. What percentage of total number Did Misha give the apples to Katya?
Solution: We use the second calculator - enter 6 in the first field, 30 in the second. We get 20%.
Task 3. At Tinkoff Bank, for replenishing a deposit from another bank, the depositor receives 1% on top of the replenishment amount. Kolya replenished the deposit with a transfer from another bank in the amount of 30,000. What is the total amount for which Kolya’s deposit will be replenished?
Solution: We use the 3rd calculator. Enter 1 in the first field, 10000 in the second. Click on the calculation and we get the amount of 10,100 rubles.