Calculate Percentage in Excel
Percentage can be explained as a proportion or ratio between two numbers in 100 scale. i.e., 250 out of 1000 is 25% (i.e., 250 : 1000 is equivalent to 25 : 100). There can be 2 scenarios You would like to calculate percentage in Excel. Let's see them with a simple example ...1. Calculate Percentage from a Number against a Total
For example, You would like to calculate what percentage is 230 out of 800. Here 800 is the Total. So, the actual mathematical formula to calculate percentage would be: (230/800) * 100 = 28.75 So, it is 28.75:100 is equivalent to 230:800. How to calculate this Excel? Here are the easy steps to solve this ..- Type =230/800 in worksheet cell A1
- Press 'Enter' to get the decimal number 28.75
- Select cell A1
- Press this shortcut key now.
- Press Ctrl + Shift + % (Keyboard shortcut to Percentage format)
- or click on Menu -> Home -> Number Tab -> %
2. Derive Number from Percentage of a Total
This is opposite of the calculation explained above. i.e., We are going to find out what is 28.75% of 800. Mathematical formula here is to multiple the Percentage & the grant total. This will give what percentage of grand total is the n%. In real life scenario: If someone has to give you a commission of 28.75% of 800$, that means you will get 230$. Here is how it is done in Excel. Yes. It is nothing new. It is just a multiplication to be true. Type in these values as explained:- 28.75% in cell A1
- 800 in cell A2
- Enter the formula '=A1*A2' in cell A3.