Formula: how to subtract percentage from a number
To subtract a percentage from a number, use the formula:
Number - (Number × Percentage / 100)This is the universal method of subtracting a percentage from a number. For example, subtracting 20% from the number 500: 500 - (500 × 20 / 100) = 400.
How to calculate percentage: practical examples
- How to subtract 10% from 1000? 1000 - (1000 × 0.1) = 900.
- To subtract 15% from 200: 200 - (200 × 0.15) = 170.
- Subtract 30% from 300: 300 - (300 × 0.3) = 210.
Excel: subtracting percentage from a number
For Excel calculation, use the formula. If the original number is in cell A1, and the percentage to subtract is 15%, enter: =A1*(1-15%). This is the simplest way to subtract percentages from a number in Excel.