When applying a price increase to a product, you usually raise the original price by a certain percent and when giving your customers discount, you would decrease that customer’s rate by a certain percent.
How to apply this in Excel? This is a very easy by using a simple formula. The figure below illustrates this:
