00:00This is how you calculate discounted amount in Excel. In my data set, I have an adjusted rate
00:05of 5% in cell E4. To calculate the adjusted price, you're going to say equal open parenthesis D7,
00:13which is your current price, multiply that by percent price change on cell E4. You're going
00:19to press F4 to make both row and column absolute, and then close parenthesis, and you plus the
00:25current price and cell D7. After that, apply the same formula to the rest of the rows. The beauty
00:31of this formula is that if you want to calculate the discounted price instead of price increment,
00:36like many things on this world these days, simply change the 5% to minus 5% and it'll give
00:42you the
00:43discounted price.
