For example, if the original, retail price of a sweater is $50, use $50 as your original price. For an hourly service, multiply the standard billing rate by the number of hours normally billed.
For example, if you ultimately paid $40 for the sweater after all discounts, the new price is $40.
In this example, the price difference is the original price of $50 minus $40, or $10.
For this example, the numerical value in cell C1 should be 50 if you enter the formula correctly.
For this example, the numerical value in cell D1 should be 0. 25 if you enter the formula correctly.
In this example, the value in cell D1 should be 25%. This means that you saved 25 percent on the purchase of the computer.
For example, say you also purchased a lamp for $10 that originally cost $17. If you type “17” into cell A1 and “10” into B1 – and leave all the other cells as they are – the corresponding savings of 41 percent will display in cell D1.
