How to do percentages in Excel

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.




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

Leave Comment