How to calculate discount percentage in excel?
Answers
As with any formula in Excel, you need to start by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. The basic formula for calculating a percentage is =part/total.
In the example below, Actual Points/Possible Points = Grade %:
Say you want to reduce a particular amount by 25%, like when you’re trying to apply a discount. Here, the formula will be: =Price*1-Discount %. (Think of the “1” as a stand-in for 100%.)
To increase the amount by 25%, simply replace the minus sign in the formula above with a plus sign.
The next example is slightly more complicated. Say the earnings for your department are $2,342 in November and $2,500 in December and you want to find the percentage change in earnings between these two months. To find the answer, divide the difference between December and November earnings ($158) by the value of the November earning ($2,342).
Answer:
calculate discount price with formula in excel... In the format cells dialogue, click
Number > Percentage, and specify the decimal places.