X

We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
DISCOVER
×
Loading ...

How to reduce the value by percentage in excel

Updated March 23, 2017

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.

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

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

  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."

Loading ...

About the Author

Carter McBride started writing in 2007 with CMBA's IP section. He has written for Bureau of National Affairs, Inc and various websites. He received a CALI Award for The Actual Impact of MasterCard's Initial Public Offering in 2008. McBride is an attorney with a Juris Doctor from Case Western Reserve University and a Master of Science in accounting from the University of Connecticut.

Loading ...