Sometimes you need to decrease a number by a certain percentage, that means you decrease percentage which is given

you can use a simple formula in excel for calculating that multiplies the number time the percent -1.

Formula

=Number * (1- Percentage)

In the figure, I am showing the percent and amount in price suppose grill cheese price is 500 and the percent is

20% for this product. Here need to decrease by the percent that means i need to calculate 100-20% i.e 80%

cell C3 is the price and B3 has its percent to decrease.

=500 * (1-20%) i.e 500 * (1-0.2)

=500 * (80%) i.e (500 * 0.8)

=400

you can use a simple formula in excel for calculating that multiplies the number time the percent -1.

Formula

=Number * (1- Percentage)

In the figure, I am showing the percent and amount in price suppose grill cheese price is 500 and the percent is

20% for this product. Here need to decrease by the percent that means i need to calculate 100-20% i.e 80%

cell C3 is the price and B3 has its percent to decrease.

=500 * (1-20%) i.e 500 * (1-0.2)

=500 * (80%) i.e (500 * 0.8)

=400

## 0 Comments

thank you for your comment