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

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

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

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

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

Very useful, thanks.

ReplyDelete