As in "Eksele" calculate percentages: key concepts

Today, many computer users interested in the question of how to "Eksele" calculate percentages.This is true because spreadsheets often contain data in numbers.When it comes to Excel, often touches upon the percentage and the difference percent.

Interest 101

While Excel can do many things, the program is not able to teach you math.Therefore, some basic knowledge you need to attend.In order to show the number as a percentage to Excel, you must use specially designed for this format.To use it, select the cells you want to format the subject, and then press the "interest" in the "number" on the "Home" (located on the tape).Talking about how to "Eksele" to calculate the interest, we note that this is done even faster if you use a hot key combination Ctrl + Shift +%.

In Excel, the basic value is always stored in decimal form.Thus, even if you use special formatting to display anything in the percentage (10%), it will be a symbolic representation of the base value.In other words, Excel always performs calculations in decimal value (0.1).To double-check it, select the cell, press Ctrl + 1 and look at the sample box in the "General search".


Formatting percentage may seem rather complicated.Therefore, to understand how to calculate percentages in Excel, you should consider the following.

format existing value : the application of a percentage value in a cell that already has data, Excel multiplies the number by 100 and adds the% sign at the end.This leads to confusion, so you must carefully to understand what is happening.

Let's assume that you type 10 in cell A2, and then apply the format%.Because Excel displays the number of multiples of 100 to show it as a percentage (remember that 1% - is one part in a hundred), you will see that 1000% is displayed in the cell rather than 10%.To work around this problem, you can calculate its value as a percentage in the first place.For example, if you enter the formula = 10/100 in cell A2, Excel will display the result as 0.1.If you can then format the decimal data, the number will be displayed as 10% - as you would expect.You can also just enter the number in decimal form directly into the cell, that is, to enter 0.1, and then apply the percentage format.This will help in the case if you are looking for an opportunity, as in "Excel" add interest or take other actions with them.

Format empty cells : Excel behaves differently when you are pre-formatted blank cells, then enter numbers.A number equal to and exceeding 1 are converted to the default interest;numbers smaller than 1, which are not negative, are multiplied by 100 to convert it into a percentage.For example, if you enter 10 or 0.1 in the reformatted cell, you will see will be a value of 10%.Now, if you type 0.1, you will see that the displayed value changes.It can also show you how to "Eksele" deduct interest.

format when entering : If you enter 10% directly in the cell, Excel will automatically apply the percentage format.This is useful when you want to enter only one percent on a sheet, for example, the amount of tax or fee.

The interest

As you type any formulas in Excel, you must start to record the value, type an equal sign (=) in the selected cell.The basic formula of how to "Eksele" calculate percentages, looks like this: = B2 / C2.

Another example would be a more complex calculation.So, if you want to reduce a certain amount by 25% when trying to apply a discount, your formula will acquire the following: = B2 * (1-C2).To increase the amount by 25%, should be replaced by a minus sign in the formula to plus.