How to Subtract Percentages in an Excel Spreadsheet? – Actions on Tables

The percentages are used for express a quantity as a fraction divided into one hundred units. Percentages are often used to calculate a product’s VAT, interest rates, markups, and discounts. In case you want to know how to subtract percentages in an Excel spreadsheet, read carefully the methods to do it.

How can you subtract in Excel? – Real numbers

In Microsoft Excel there is no SUBTRACT function. Therefore, to subtract amounts and ranges in Excel, the arithmetic operator – is used directly. Also, it is possible to use the SUM function if you have negative values. In this way, the application will take care of perform subtraction to output a result.

Therefore, if you want to subtract two numbers, you just have to go to the cell where you want to see the result. Then click in the formula bar and type =value1-value2. Another way to subtract is to use cell references like this: =A1-B1. To subtract a range of values that includes multiple negative numbers, use the formula =SUM(A1:A5).

How can you get the percentages of the data in tables?

To do this, you will need to make a table in Excel, enter values ​​into it, and select an empty cell where you want to see the result. Then, write the instruction that allows you to divide the numerical value with the requested percentage and multiply it by 100.

For example, you can know the discount percentage of a product that used to cost $25 and now costs $18. To get the percentage, you must type = (A1/18) * 100 and press ‘Enter’, A1 holds the value ’25’. Then, click on the right end of the cell where you got the result and drag the cursor to get the percentage of the rest of the cells.

What should you do to subtract a percentage from your table in Excel?

It is possible to subtract a percentage from your table in Excel. For this, you should refer to cell where is the value you want to subtract. Then, it is necessary to use the subtraction operator – and multiply that value by the percentage. For example, if cell A1 contains the price of a product and you want to apply the 30% discount, the formula would be = A1-(A1*0.30).

If the percentage is expressed in a cell with the symbol % then the formula will be = A1 – (A1*B2). Being B2 the cell that contains the value of 30%. In case you have a price range and the discount percentage (30%) in a single cell, you must assign a name to said cell. Then apply the formula and drag the cursor for the entire range.

How can you add percentages of the data in your spreadsheet tables?

it’s possible add percentages of the data in your tables of spreadsheets. To achieve this, place the cursor next to the first element of the table. Then write the formula = A2 + (A2*B2) where A2 is the cell of the first element and B2 is the cell that contains the percentage expressed with the % symbol.

There is another way to add percentages of the data in your tables, which you can express the percentage value in decimal form and multiply it by the element of the cell. This element will be added to the result of the previous operation. Therefore, the formula can be expressed as follows: = A2 + (A2*0.25) the value 0.25 refers to 25%.

What other actions can be performed in Excel with percentages?

There are other things you can do in Excel with percentages. In this regard, this application allows you to perform additions between percentage columns, multiplications and references. You can also express numeric values ​​in decimal format before apply any operation on the spreadsheet.

Sums between percentage columns

Once you have the list of percentage values ​​in a table, you will need to modify its format. This will allow Excel to recognize that these are percentage values. For this, select the range of cells and access the ‘Number’ format and then choose the ‘Percentage’ option.

You can even express values ​​in decimal format in order to add them. This way, it will be easier to apply the sum. So place the cursor in the last cell after the last element that makes up the percentage column and type the formula =SUM(A1:A5) where A1:A5 is the range of elements.

Multiplications and references

Microsoft Excel allows you to perform multiplications and use formula references. In the case of multiplication, the application allows the use of the PRODUCT function. Such a function requires a range of integer or decimal numeric values. Also, you can do individual cell references and use the arithmetic operator *.