How Do You Subtract a Percentage From a Sum in Excel?
You can use several techniques to subtract a percentage from a sum in Excel. The Houston Chronicle elaborates on a simple method that can be used in versions of the software up to MS Excel 2013.
-
Calculate the sum
The first step is to calculate the sum with the formula “=sum(cellX:cellY)” entered below the cell range of a sum. For example, the sum for cells A1 to A10 is calculated with the formula “=sum(A1:A10)” inserted into the cell A11.
-
Enter percentage to be deducted
The percentage to be deducted from the sum should be entered into the adjacent cell of the sum. In this example case, cell B11.
-
Enter final calculation formula
The formula “=cell of the sum-(cell of the sum * cell of the percentage followed by %)” is used to calculate the final result. In the example above, formula “=A11-(A11*B11%)” would deduct a percentage set in the cell B11 from the sum of the cell range A1 through A10.
