How To Add Percentages In Excel

Table of contents:

How To Add Percentages In Excel
How To Add Percentages In Excel

Video: How To Add Percentages In Excel

Video: How To Add Percentages In Excel
Video: Calculating percentages in Excel 2010, 2013, 2016 2024, March
Anonim

The spreadsheet editor Microsoft Office Excel allows you to easily perform calculations with relatively small data sets. This application has its own set of rather complex functions, and operations such as adding percentages can be performed without even involving them.

How to add percentages in Excel
How to add percentages in Excel

It is necessary

Microsoft Office Excel spreadsheet editor

Instructions

Step 1

Let's say you need to add a fixed percentage to the original number placed in cell A1 and display the result in cell A2. Then a formula should be placed in A2 that increases the value from A1 by some factor. Start by determining the magnitude of the multiplier - add one hundredth of a fixed percentage to one. For example, if you need to add 25% to the number from cell A1, then the multiplier will be 1 + (25/100) = 1.25. Click cell A2 and type the required formula: enter the equal sign, click cell A1, click the asterisk (operation sign multiplication) and print the multiplier. The entire record for the above example should look like this: = A1 * 1, 25. Press Enter and Excel will calculate and display the result.

Step 2

If you need to calculate the same percentage of the values in each cell of a certain column and add the resulting value to the same cells, then put the multiplier in a separate cell. Let's say you need to add 15%, and the original values are from the first to the twentieth lines in column A. Then put the value 1, 15 (1 + 15/100) in a free cell and copy it (Ctrl + C). Then select the range from A1 to A20 and press the key combination Ctrl + alt="Image" + V. The "Paste Special" dialog will appear on the screen. In the "Operation" section, check the box next to the word "multiply" and click the OK button. After that, all the selected cells will change by the specified percentage value, and the auxiliary cell containing the multiplier can be deleted.

Step 3

If it is necessary to be able to change the added percentage, it is better to place it in a separate cell, and not to correct it every time in the formula. For example, put the original value in the first row of the first column (A1), and the percentage to be added in the second column of the same row (B1). To display the result in cell C1, enter the following formula: = A1 * (1 + B1 / 100). After pressing the Enter key, the desired value will appear in the column if cells A1 and B1 already contain the required values.

Recommended: