articles

Home / DeveloperSection / Articles / How to do percentages in Excel

How to do percentages in Excel

AVADHESH PATEL5252 15-Mar-2013

In this article I have described to calculate percentages between different cell values. For example compute a sales tax, or determine a percent change in sales between two fiscal quarters etc. There are several ways to calculate percentages.

 Percentages are calculated by using the following equation: 

amount/total = percentage 

Note: Percentage is in decimal format. 

For demonstration I have get percentage of get marks as below image data. 

=B8/C8*100 

How to do percentages in Excel 

Now, let's say that you want to reduce a particular amount by %, like when you're trying to apply a discount. Here's a formula that would get you that result. (Think of the 1 in the formula below as a stand-in for 100%.) 

How to do percentages in Excel


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By