Multiply the resultant number by 100. 400 100 percent - 20 percent x original price. Select a blank cell for instance the Cell C2 type this formula B2-A2ABS A2 the Cell A2 indicates the original price B2 stands the sales price you can change them as you need into it and press Enter button and then drag the fill handle to fill this formula into the range you want.
400 100 percent - 20 percent x original price.
Calculate discount rate with formula in Excel. To calculate the percentage discount between two prices follow these steps. If youre still paying 75 youre not paying 25 the percentage discount. Use the formula C2B2 in column D to calculate the what percentage of the number in column B is represented by the number in column C.