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 this 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.
Basic definitions and properties were discussed. In this section, we'll figure out how to increase or decrease a number by a few percent and look at some other issues. If all this seems obvious to you, you can immediately skip to parts 3 - 5 of this article.
How to increase the number by a few percent. Method I
Let's start with an easy example:
Example 5. The price of the shirt increased by 20%. How much does a shirt cost now, if before the price increase it cost 2,400 rubles?
1) Find 20% of the number 2400. In the first part of the article, we discussed in detail how this is done. To find 20% of 2400, you need to multiply 2400 by twenty hundredths: 2400 * 0.2 = 480.
2) The shirt cost 2400 rubles, the price increased by 480 rubles, now the shirt costs 2400 + 480 = 2880 rubles.
Answer: 2880 rub.
If we need to reduce the number by a few percent, the reasoning is similar.
Task 7. Increase the number 250 by 40%. Reduce 330 by 12%.
Task 8. The jacket cost 18,500 rubles. During the sale the price was reduced by 20%. How much does the jacket cost now?
How to increase the number by a few percent. Method II
Let's try to solve the previous problem a little faster.
During the solution, we add twenty percent to the number 2400: 2400 + 2400 * 0.2.
Let's take the common factor out of brackets and get: 2400*(1 + 0.2) = 2400*1.2.
Conclusion: to increase the number by 20%, you should multiply it by 1.2.
Now let's formulate general rule. Suppose we need to increase the number A by t%. t% of A is t hundredths. We get:
A + A ⋅ t 100 = A ⋅ (1 + t 100)
We arrive at the following general rule:
To increase the number A by t%, you need to multiply A by (1 + t 100) .
Example 6. Increase the number 120 by 17%, the number 200 by 2%, and the number 10 by 120%.
120 ⋅ (1 + 17 100) = 120 ⋅ 1,17 = 140,4 200 ⋅ (1 + 2 100) = 200 ⋅ 1,02 = 204 10 ⋅ (1 + 120 100) = 10 ⋅ 2,2 = 22
Perhaps it is not yet very noticeable how much simpler and faster method No. 2 is compared to method No. 1. At the end of this part of the article we will look at solving the problem where the advantages of the second method will become obvious. And now - another task for independent work.
Task 9. Increase the number 1200 by 4%, the number 12 by 230%, and the number 57 by 30%.
How to reduce a number by a few percent
Literally repeating the reasoning from the previous paragraph verbatim, we arrive at the following rule:
To decrease the number A by t%, you need to multiply A by (1 − t 100) .
Example 7. There were 30 mosquitoes in the room at night. By morning their number had decreased by 40%. How many mosquitoes are left in the room?
We must reduce the number by 40%, i.e. multiply 30 by (1 − 40 100) = 1 − 0.4 = 0.6.
30*0,6 = 18.
Answer: 18 mosquitoes.
Task 10. Reduce the number 12 by 20%, reduce the number 14290 by 95%.
Twice 10% is not 20%!
Example 8. Two jackets cost 14,000 rubles each. The price of one of them was increased by 10%, and then by another 10%. The price of the second jacket was immediately increased by 20%. Which jacket costs more now?
"Why does one of them have to be more expensive?" - the reader asks in bewilderment. - “The jackets cost the same, 20% is two times 10%, which means now they also cost the same.”
Let's try to understand the situation. The first jacket increased in price by 10% twice, i.e. its cost increased twice by 1.1 times. Result: 14000*1.1*1.1 = 16940 (r). The second jacket immediately increased in price by 20%, its price was increased by 1.2 times. We calculate: 14000 * 1.2 = 16800. As you can see, the prices turned out to be different, the first jacket has risen in price more.
"But why doesn't 10% + 10% equal 20%?" - you ask.
The problem is that 10% the first time is taken from 14,000 rubles, and the second time - from the increased price.
10% of 14000r = 1400r. After the first price increase, the jacket costs 14,000 + 1,400 = 15,400 (r). Now we are rewriting the price tag again. We take 10%, but not from 14000, but from 15400: 15400*0.1 = 1540 (r). We add 1540 and 15400 - we get the final price of the jacket - 16940 rubles.
Task 11. If the starting price of the jacket were different, would the answer be different? Think about this question: take several starting price options, do the calculations. Try to prove that two 10% price increases always lead to a higher price than one 20% increase.
They raised the price by 20%, then reduced it by 20%. Back to original price?
Example 9. Actually, the task is already stated in the title. To make it easier to reason, let's modernize it a little. The jacket costs 16,000 rubles. The price was increased by 20%, and the next day - reduced by 20%. Is it true that now the jacket costs 16,000 rubles again?
No, that's not true. Short solution: 16000 * 1.2 * 0.8 = 15360 rubles - the price of the jacket has decreased.
Long solution. First, the price of the jacket increased by 20%, i.e. by 16000 * 0.2 = 3200 rubles. On the new price tag - 16000 + 3200 = 19200 (r). The next day the price is reduced by 20%. But this is already 20% not of 16,000, but of 19,200: 0.2 * 19,200 = 3,840 rubles. 19200 - 3840 = 15360 (r).
It is clear why in the end the price became lower: 20% of 19,200 is more than 20% of 16,000.
Again, I encourage you to think about how the answer would be different if the initial price of the jacket was different? Conduct several experiments: take different initial prices, carry out calculations and make sure that the final price is lower, and always by the same percentage. Can you solve this problem in general view, i.e. find out by what percentage the price of the jacket will decrease after a successive 20% increase and 20% decrease? Try it! If you can't do it yourself, look at part 3 of this article.
Several price tag changes
Example 10. In January, the cost of an apartment in a new building was 12,000,000 rubles. In February it increased by 5%, in March it decreased by 3%, in April it increased again by 7%, and in May it decreased by 10%. How much does an apartment cost now?
Solution. I hope that young mathematicians, armed with the experience of Examples 8 and 9, will not argue that the price has changed by 5% - 3% + 7% - 10% = -1%. This is a big mistake! The price changes each time from a new amount, so you can’t just add and subtract in the hope of getting the final change as a percentage.
Let me give you a detailed solution first.
The first price increase is 5% of 12,000,000 = 600,000 (r).
12,000,000 + 600,000 = 12,600,000 (r).
The first price reduction is 3% of 12,600,000 = 378,000 (r).
12,600,000 - 378,000 = 12,222,000 (r).
The second price increase is 7% of 12,222,000 = 855,540 (r).
12,222,000 + 855,540 = 13,077,540 (r).
The final price reduction by 10% is 10% of 1,307,7540 = 1,307,754 (r).
13 077 540 - 1 307 754 = 11 769 786.
U-ff-ff, exhale!
Do you like this solution? No to me! Why these 8 actions if everything can be fit in one line:
12,000,000*1.05*0.97*1.07*0.9 = 11,769,786 (r).
I specifically included these two solutions so that you realize how much easier it is to use compared to . Unfortunately, schoolchildren rarely use the second method, preferring long arguments, like those we cited above. We need to gradually give up this bad habit!
Test No. 2
You are again invited short test. Let me remind you that the answer (as in the Unified State Examination in mathematics) is an integer or a finite number decimal. Always use a comma as a decimal separator (for example, 1.2, but not 1.2!) Good luck!
Interest rates are everywhere in the modern world. 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 lessons mathematics where you learned 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 “-”. The 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 everything numeric values(except for the total) and select a 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, write to us. We will try to help you.
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 and 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.
Working in Excel program Often there is a need to add or subtract some percentages from a number. This may be due to the need to add a VAT percentage or calculate profit. Whatever it is specific task, it can be solved in Excel.
Now we will talk about how to add a percentage to a number in Excel. The material will be useful for users of all versions of Excel, including Excel 2003, 2007, 2010, 2013 and 2016.
To explain how to add a percentage to a number, let's look at a simple example. Let's say you have a number to which you need to add a certain percentage (for example, you need to add 18% VAT). And in the next cell you want to get the value with the percentage already added.
To do this, you need to select the cell where the result should be located and enter the formula into it. As a formula, you can use this simple construction: =A2+A2*18%. Where A2 is the cell containing the original number, and 18 is the percentage you want to add to this original number.
Once you have entered the formula, you just need to press the Enter key on your keyboard and you will get the result. In our case, we added 18 percent to the number 100 and got 118.
If you don’t want to add a percentage, but subtract it, then this is done in a similar way. Only the formula uses a minus rather than a plus.
If necessary, the percentage that you will add or subtract can not be indicated directly in the formula, but taken from the table. For this case, the formula needs to be slightly modified: =A2+A2*B2%. As you can see, in the formula, instead of a specific percentage value, the cell address is used, and after it the percentage.
After using this formula, you will receive a number with the percentage added to it, which was indicated in the table.
Possible problem when adding interest
It should be noted that when working with percentages, you may end up with some too large numbers, as well as the percentage sign, starting to appear in your cells.
This happens in cases where the user first enters the formula incorrectly and then corrects it. For example, in the case of adding 18 percent, you can make a mistake and enter: =A2+18%.
If you correct yourself after this and enter the correct formula =A2+A2*18%, then you will get some incredibly large number.
The problem is that as a result of introducing the first formula, the cell format changed from numeric to percentage. To fix this, right-click on the cell and go to “Format Cells”.
In the window that opens, select the cell format that will suit it.
Most often, it is general or numeric. After selecting the desired format, save the settings using the “Ok” button.
