How to calculate percentage in Excel tutorial

This is a Microsoft Excel tutorial on how to calculate percentage in any version of Excel. Here are simple steps you can follow:

How many percent is X from Y? 

Example: the original price of a product is 79 $ and it is now sold with 42 $. How much is the discount percentage?



Correct formula: X/Y*100, but in in our example: B2/A2.

How to calculate percentage in Excel tutorial

We get a result of 0,53. Change the formatting of the cell to percentage (in the home tab, under data click the % mark) and you get 53%.

How to calculate percentage in Excel tutorial

 

How much is X% from Y?

 

Example: the original price of a product is 159 $ and it is now sold with 15 % discount. How much is the discount?
Formula in this case 15/100*159. 
Note: the if the 15 % value has been formatted to percentage, the real value in the cell is 0,15. Excel just shows it as 15 %.
This means you don't have to divide the 15% with 100, so you just multiply: B2*A2. 

How to calculate percentage in Excel tutorial

You should get a result of 23,85 $. If the result is showing as a percentage, change the cell formatting to value (in the home tab, under data click the drop down menu).

How much is Y if we take X% off?

 

Example: the original price of a product is 159 $ and it is now sold with 15 % discount. How much is the final price?
Use this formula Y-X%/100*Y.  In our example =A2-B2*A2 (Remember the value in 15 % cell is really 0,15).

How to calculate percentage in Excel tutorial


You should get a result of 135,15 $. If the result is showing as a percentage, change the cell formatting to value (in the home tab, under data click the drop down menu).

How much is Y if we add X% to it?

 

Example: the original price of a product is 159 $ and the price is rised with 15 %. How much is the final price?
Use this formula Y+X%/100*Y. In our example =A2+B2*A2 (Remember the value in 15 % cell is really 0,15).

How to calculate percentage in Excel tutorial


You should get a result of 182,85 $. If the result is showing as a percentage, change the cell formatting to value (in the home tab, under data click the drop down menu).

No comments:

Post a Comment