This example explains the general formula for increasing a number by a given percentage. For example, with -10% in cell D5 (-0.10), the formula evaluates like this: =C5*(1-D5) Negative percentagesĪ negative percentage will have the effect of increasing the original price. The general formula for this calculation, where "x" is the new price, is: x=old*(1-percentage)Ĭonverting this to an Excel formula with cell references, the formula in E5 becomes: =C5*(1-D5)Īs the formula is copied down, the formula returns a new price for each item in the table, based on the percentages shown in column D. For example, given an original price of $70.00, and an decrease of 10% ($7.00), the result should be $63.00. In this example, the goal is to decrease the prices shown in column C by the percentages shown in column D.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |