In life, sooner or later, everyone will face a situation where it will be necessary to work with interest. But, unfortunately, most people are not ready for such situations. And this action is difficult. This article will explain how to subtract percentages from a number. Moreover, various ways of solving the problem will be analyzed: from the simplest (using programs) to one of the most complex (using a pen and a leaf).
Take away manually
Now we will learn how to subtract a percentage of the number using a pen and a piece of paper. The actions that will be presented below are studied by absolutely everyone at school. But for some reason, not everyone remembered all the manipulations. So, what you will need, we have already figured out. Now we will tell you what to do. To make it more clear, we will consider an example, taking specific numbers as a basis. Suppose you want to subtract 10 percent from the number 1000. Of course, it is quite possible to turn these actions in your mind, since the task is very simple. The main thing is to understand the essence of the decision.
First of all, you need to write down the proportion. Let's say you have two columns with two rows. One thing to remember: the numbers fit in the left column, and the percent in the right column. Two values will be written in the left column - 1000 and X. X is entered because it is it that symbolizes the number that will need to be found. In the right column will be entered - 100% and 10%.
Now it turns out that 100% is the number 1000, and 10% is X. To find the X, you need to multiply 1000 by 10. The resulting value is divided by 100. Remember: the necessary percentage should always be multiplied by the taken number, after which the product should be divided by 100%. The formula looks like this: (1000 * 10) / 100. The picture will clearly show all the formulas for working with percentages.
We got the number 100. That is what lies under the same X. Now all that remains to be done is to subtract 100 from 1000. It turns out 900. That's all. Now you know how to subtract percentages from a number using a pen and notebook. Practice yourself. And over time, these actions you can perform in the mind. Well, we move on, talking about other ways.
Subtracting with Windows Calculator
Clear business: if there is a computer at hand, few will want to use a pen and a notebook for calculations. Easier to use the technique. That is why now we will consider how to subtract percentages from a number using the Windows calculator. However, a small remark is worth making: many calculators are able to perform these actions. But the example will be shown using the Windows calculator for a better understanding.
Everything is simple here. And it is very strange that few people know how to subtract percentages from the number in the calculator. Initially open the program itself. To do this, go to the "Start" menu. Next, select "All Programs", then go to the "Standard" folder and select "Calculator".
Now everything is ready in order to proceed with the decision. We will operate with the same numbers. We have 1000. And 10% should be taken away from it. All you need is to enter the first number (1000) into the calculator, then click minus (-), and then click on the percentage (%). Once you have done this, you will immediately see the expression 1000-100. That is, the calculator automatically calculated how much it is 10% of 1000.
Now press Enter or equal to (=). Answer: 900. As you can see, both the first and second methods led to the same result. Therefore, it is up to you to decide how to use it. Well, in the meantime, we move on to the third, final option.
Subtract in Excel
Many people use Excel. And there are situations when it is vital to quickly make a calculation in this program. That is why now we will figure out how to subtract a percentage of a number in Excel. In the program, this is very simple using formulas. For example, you have a column with values. And you need to take 25% from them. To do this, select the column next to and in the field for formulas write equal to (=). After that, click LMB on the cell with the number, then put “-” (and again click on the cell with the number, then enter - “* 25%). You should get it, as in the picture.
As you can see, this is the same formula as given for the first time. After pressing Enter you will get a response. To quickly subtract 25% of all numbers in a column, you just need to hover over the answer by placing it in the lower right corner and drag it down to the desired number of cells. Now you know how to take a percentage of a number from Excel.
Conclusion
In the end, I want to say only one thing: as can be seen from the foregoing, in all cases only one formula is used - (x * y) / 100. And it was with its help that we managed to solve the problem in all three ways.