Subtracting Percentage from Subtotal in Google Sheets

Formula to Subtract a Percentage from a Subtotal in Google Sheets

Formula Structure

To subtract a percentage from a subtotal, you can use the following formula:

= subtotal * (1 - percentage)

Components of the Formula

• subtotal: This is the cell reference where your subtotal is located (e.g., A1).
• percentage: This is the cell reference for the percentage you want to subtract (in decimal form). For instance, if the percentage is 20%, it should be entered as 0.20 in cell B1.

Complete Formula Example

If your subtotal is in cell A1 and you want to subtract 20% from it, the formula would look like this:

= A1 * (1 - B1)

Assuming B1 contains the value 0.20.

Explanation of the Formula

1. Multiplication: The subtotal is multiplied by (1 - percentage), which effectively reduces the subtotal by the specified percentage.
2. Percentage Calculation: The expression (1 - B1) represents the remaining percentage after the specified percentage is subtracted. For example, if B1 is 0.20, then (1 - 0.20) equals 0.80, meaning 80% of the subtotal remains.

Practical Illustration

Scenario

• Subtotal (in cell A1): 100
• Percentage to subtract (in cell B1): 0.20 (which is 20%)

Application of the Formula

1. Input Values:

   • A1: 100
   • B1: 0.20

2. Formula in Use: Enter the following formula in cell C1:

= A1 * (1 - B1)

3. Result:
   • C1 will display 80, which is the result of subtracting 20% from the subtotal of 100.

Summary

• Formula: = subtotal * (1 - percentage)
• Example: = A1 * (1 - B1) where A1 = 100 and B1 = 0.20 results in 80.
• This formula effectively allows you to calculate the balance after a specified percentage deduction from a subtotal efficiently.

For further enhancement of Google Sheets skills, consider exploring the courses available on the Enterprise DNA Platform.