Selling Price Cost Price 1-Gross Profit The Excel formula that would be used for this example is. If you want to increase a number by a certain percentage follow these steps. Subtract the original value from the new value.
Original price 30original price sale price.
Percentage increasedecrease calculation The percentage increasedecrease from old value V old to new value V new is equal to the old and new values difference divided by the old value times 100. Step 1 Get the percentage of the original number. The original price is 100 percent and 30 percent has been taken off so the sale price is 70 percent of the original price. Divide the final amount by the decimal to find the original amount before the percentage was added.