Just so as you get it put away in your head for future use, go and teach what you understand to mum and then to dad.
To calculate a discount, start by converting the discount percentage to a decimal.
Don't need any special skills, save two hours every day!
100 percent simply means the whole lot.200 New Features for Excel, Make Excel Much Easy and Powerful: Merge Cell/Rows/Columns without Losing Data.But if the different kinds of items have different discounts, how can you calculate the discount rates or prices of the different items?When Christmas is coming, there must be many sale promotions in shopping malls.Best Answer: First, we must understand what percentage means.Select the formula range cells, in this case, select the range C2:C5, right click Format Cells.Next, multiply the original price by the decimal either by hand or by using a calculator.Select a blank cell, for instance, the Cell C2, type this formula A2-(B2*A2) (the Cell A2 indicates the original price, and the Cell B2 stands the discount rate of the item, you can change them as you need press Enter button and drag the fill.
In the, format Cells dialog, click, number Percentage, and specify the decimal places then click.
In this case it comes out as a whole price discount.Hence, 40 of 399 ( 40/100 x 399).Take away the discount from the 399 price tag and you have your answer.So, 40 of 100 40/100 4/10 2/5 which is the same.4.Kutools for Excel Amazing!Now, I talk about two formulas for you to calculate the discount rates and discount prices in Excel.Combine and Consolidate Multiple Sheets and Workbooks.This gives you the discount amount, or what value is being taken off the original price.
Now that is a very easy puzzle to solve.