The formula to calculate the discounted price in Excel 2016 is as follows:
=original_price * (1 - discount_rate)
Where "original_price" is the original price of the item and "discount_rate" is the percentage discount. For example, if the original price of an item is $100 and the discount rate is 20%, then the discounted price would be:
=100*(1-20%) = $80
Ещё видео!