How to calculate percentage in excel - youtube
- how to calculate percentage off in excel
- how to calculate percentage discount in excel
- how to work out percentage off in excel
- how to find percentage off in excel
Percentage calculator...
Excel Formulas: Percent-Off Sale
Lesson 12: Percent-Off Sale
/en/excelformulas/overbudget-items/content/
"Hey, could you help me out?10 discount formula in excel
I want to buy some new stuff for my bike, and there's this great sale today—everything is 15% off.
Can you help me figure out how much it will cost after the discount? I added the basic info to a spreadsheet if that makes it any easier."
Our spreadsheet
Once you've downloaded our spreadsheet, open the file in Excel or another spreadsheet application.
Here, we have two main columns: one for the item name, and another for the item price. There's also a formula in cell B5 that calculates the original total cost of the items: =SUM(B2:B4)
What are we trying to figure out?
Let's think about the problem we're trying to solve.
We want to know the total cost after the discount. A discount is a percentage of the original price. In this example, the discount is 15% of the original total.
To make this problem easier to solve with a spreadsheet, we'll break it down into two steps:
- Find the
- how to calculate percentage off price in excel
- how to calculate discount percentage in excel sheet