Percentages are used to express a quantity as a fraction divided into one hundred units. The percentages are often used to calculate the VAT of a product , interest rates, increases and discounts. In case you want to know how to subtract percentages in an Excel spreadsheet, read carefully the methods to do it.
Index( )
- How can you subtract in Excel? – Real numbers
- How can you get the percentages of the data in tables?
- What should you do to subtract a percentage from your table in Excel?
- How can you add percentages of the data in your spreadsheet tables?
- What other actions can be performed in Excel with percentages?
- Sums between percentage columns
- Multiplications and references
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 performing the subtraction to emit 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 in 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 find out 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 must refer to the cell where the value you want to subtract is. 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 that 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 is possible to add percentages of the data in your spreadsheet tables. 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 as a decimal 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 applying any operations in the spreadsheet .
Sums between percentage columns
Once you have the list of percentage values in a table, you 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 the values in decimal format to be able 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 multiplication 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. You can also make references to individual cells and use the arithmetic operator *.