To subtract a percentage value such as 50 from a number youll need to enter the value in a cell with percentage format. A represents the start or inicial value and B the percent we want to subtract. Go to Format Number Percent in Google Sheets menu to apply the percentage view.
To subtract 25 percent from a price of 20 first convert 25 percent into a decimal.
This formula can now be copied down the column. This formula can now be copied down the column. - deduct X percent from Y number. Get total from percentage In the example the active cell contains this formula.