How to subtract interest from a number: three effective ways

In life, sooner or later, everyone will faceThe situation when it will be necessary to work with interest. But, unfortunately, most people are not ready for such situations. And this action causes difficulties. This article will tell you how to subtract interest from a number. Moreover, various ways of solving the problem will be analyzed: from the simplest (with the help of programs) to one of the most complicated (with the help of a pen and a sheet).

We take away manually

Now we learn how to subtract a percentage of the number fromusing the pen and the sheet. Actions that will be presented below are studied by absolutely everyone at school. But for some reason not everyone remembers all the manipulations. So, what you will need, we have already figured out. Now tell you what to do. To make it more clear, we will consider the example, taking as a basis specific numbers. Let's say you want to take away 10 percent of the number 1000. Of course, it's quite possible to crank these actions in your mind, since the task is very simple. The main thing is to understand the very essence of the solution.

First of all you need to write downproportion. Suppose you have two columns with two rows. Remember you need one thing: in the left column, numbers are entered, and in the right column - percentages. In the left column, two values, 1000 and X, will be recorded. The X is inscribed because it symbolizes the number to be found. In the right column will be inscribed - 100% and 10%.

Now it turns out that 100% is the number 1000, and10% - X. To find the X, you need to multiply 1000 by 10. The resulting value is divided by 100. Remember: the required percentage must always be multiplied by the number taken, 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 interest.

We got the number 100. It is this that lies under the very same Ix. Now all that's left to do is take 1000 away from 1000. It turns out 900. That's all. Now you know how to take interest from a number with a pen and a notebook. Practice yourself. And over time, these actions you can do in your mind. Well, we move on, talking about other ways.

We take it away with the Windows calculator

Clear business: if there is a computer under your hand, very few people will want to apply a pen and notebook for calculations. It's easier to use machinery. That's why now consider how to take interest from a number using the Windows calculator. However, it is worth making a small remark: many calculators are able to perform these actions. But the example will be shown using the Windows calculator for more understanding.

Here everything is simple. And it is very strange that very few people know how to take interest from the number in the calculator. Initially, open the program itself. To do this, go to the "Start" menu. Then select "All Programs", then go to the "Standard" folder and select "Calculator".

Now everything is ready to proceedsolution. We will operate on the same numbers. We have 1000. And from it it is necessary to take away 10%. All you need is to enter the first number (1000) in the calculator, then press the minus (-), then click on the percentage (%). Once you do this, you will immediately find the expression 1000-100. That is, the calculator automatically calculated how much is 10% of 1000.

Now press Enter or equal (=). Answer: 900. As you can see, both the first and second method led to the same result. So it's up to you to decide which way to use it. Well, while we are moving on to the third, last option.

We extract in Excel

Many people use Excel. And there are situations when it is vital to quickly make a calculation in this program. That's why now we'll figure out how to take a percentage of the number in Excel. In the program, it is very easy to do this using formulas. For example, you have a column with values. And you need to take 25% from them. To do this, select the column beside it and enter in the formula field equal (=). 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, as in the picture.

As you can see, this is the same formula aswas given for the first time. After pressing Enter you will get an answer. To quickly take away 25% of all the numbers in the column, just point the cursor at the answer, placing it in the lower right corner, and drag it down to the desired number of cells. Now you know how to take the percentage of the number in Excel.

Conclusion

Finally, I want to say only one thing: as can be seen from all of the above, in all cases only one formula is used - (x * y) / 100. And it was with her help that we managed to solve the problem in all three ways.