How to calculate interest in Excel

In the process of solving various types of tasks, both training and practical, users are often refer to the Excel program.

The spreadsheet allows you to analyze data, build diagrams and graphs, as well as perform a variety of calculations. One of the common operations is the calculation of interest. The ability to competently produce the necessary calculations is a useful skill that finds successful use in almost all spheres of life. What techniques will help calculate interest using Excel tables?

1

How to calculate interest in Excel - the main formula for calculating

Before proceeding to calculate interest, it is necessary to determine the terminology. The term "percentage" means the number of fractions of all 100 fractions of the whole. The mathematical definition of the percentage is a fraction whose numerator determines the desired number of parts, and the denominator is general. The result is multiplied by 100 (because integer - 100%). Working with the spreadsheet, the formula for determining the percentage is as follows:

Part / integer \u003d percentage

From the usual interpretation in mathematics distinguishes only the lack of further multiplication by 100. Get the required value format will help the properties of the table fields - it suffices to activate the percentage of cell format.

Example 1.

Before you, a number of data made, for example, in the column D (d2, d3, d4, d5, ...). It is necessary to calculate, 5% of each value.

• Activate the neighboring value (or any other) cell - the result of calculations will be located in it.
• In the E2 cell, write the expression "\u003d d2 / 100 * 5" or "\u003d d2 * 5%".
• Jump ENTER.
• "Detach" the E2 cell on the required number of rows. Thanks to the autocopter marker at the above formula, it will be calculated for other values.

Example 2.

Before you are 2 columns of values \u200b\u200b- for example, realized cakes (D2, D3, D4, D5, ...) and the total amount of baking (E2, E3, E4, E5, ...) of each type. It is necessary to determine which part of the products is implemented.

• In the cell, where the result will be calculated (for example, f) write the expression "\u003d D2 / E2".
• Click ENTER and "stretch out" the cell on the required number of lines. The use of the autocomplete marker will allow you to apply this formula for all subsequent cells and produce loyal calculations.
• To transfer the result in percent format, select the necessary cells and use the PERCENT STYLE command. To activate the latter, you can click on the right mouse button and select the "Format of the cells" in the list appeared in the list. At the same time, you specify the desired number of decimal signs. Or go to the "Home" section - "Number" section and select the view "percentage".

2

How to calculate interest in Excel - percentage of the amount

To calculate the share of each part relative to the total amount, use the expression "\u003d A2 / $ A $ 10", where A2 is an important value, the total amount is indicated in the cell A10. How to be if the position of interest is interested in the table several times? In this case, use the SUMIF function with the parameters:

\u003d SUMIF (Range, Criteria, Sum_Range) / Total

Or

\u003d Smereys (range; Criterion; Range_Summing) / Total

• Move into a cell where the result will be obtained.
• Record the expression "\u003d silent (C2: C10; F1; D2: D10) / $ D $ 14" (or \u003d SUMIF (C2: C10; F1; D2: D10) / $ D $ 14), where

C2: C10, D2: D10 - Ranges of values, within which calculations occur,

F1 is the cell in which the characteristic studied is indicated,

D14 is a cell in which the amount is calculated.

3

How to calculate interest in Excel - change in percent

The need for such calculations often occurs during an increase assessment or decreased by the results of activities. So, sales volumes by product categories for 2015. Made in column D, similar data for 2016. - In the E column. It is necessary to determine how many percent increased or the sales volume decreased.

• In the F2 cell, indicate the formula "\u003d (E2-D2) / D2".
• Translate the cell data into the percentage format.
• To calculate the growth or loss for the remaining categories (cells), stretch F2 to the required number of rows.
• Evaluate the result. If the value is positive - you have an increase, if negative is a decrease.