Instructions on how to calculate interest in Excel

The spreadsheet editor "Excel" is rightfully considered the best. Its functionality has many tools that are designed to facilitate the work of the user. Listing them all will not be enough for any article, but talking about some of the features is another matter.

This article will discuss how to calculate percent in Excel. Several methods will be demonstrated by which you can easily make the necessary calculations.

Formula

First of all, before calculating the percent in Excel, you should pay attention to the formula itself, so that in the future you can use it, substituting your values. It looks like this:

Now consider its use. As an example, we will use the numbers 9 and 17, where 9 is the number and 17 is the total.

Presets

, , Excel , , "" "", .

. 9 17, :

1. .
2. . "=9/17" ( , , 100 ).
3. ENTER.

- , . , Excel , , .

, "", , .

, , , :

1. ( , ).
2. (=).
3. () .
4. (/).
5. .
6. ENTER.

, . , Excel.

Excel , . , :

1. , , .
2. , (/), ($), , : "=E3/$E$8".
3. ENTER, .
4. , .

. , , .