How to reduce the value by percentage in excel

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel allows you to calculate different formulas. One such formula is the reduction of a number by a certain percentage. For the calculation, you need to remember that it is not simply multiplying the number by the per cent. If you do this, you just find the per cent of your value. To reduce the number by your percentage, you need to also subtract it from your original value. You can complete this with one formula.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Type your value in cell A1. For example, Type "50" in cell A1.

  2. 2

    Type the percentage in cell A2. In the example, type "30%."

  3. 3

    Type "=A1-(a1*a2)" in cell A3. In the example, you will get 35. This is because 30 per cent of 50 is 15, so then "50 minus 15 equals 35."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.