The basic formula for calculating a percentage is =part/total. 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 %.

How do you apply a discount in Excel?

If you know the original price and the discounted price, you can calculate the percentage discount.

  1. First, divide the discounted price by the original price.
  2. Subtract this result from 1.
  3. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.

How do you do a discounted cash flow in Excel?

How to Use the NPV Formula in Excel

  1. =NPV(discount rate, series of cash flow)
  2. Step 1: Set a discount rate in a cell.
  3. Step 2: Establish a series of cash flows (must be in consecutive cells).
  4. Step 3: Type “=NPV(“ and select the discount rate “,” then select the cash flow cells and “)”.

How do you subtract 20% from a price?

To subtract any percentage from a number, simply multiply that number by the percentage you want to remain. In other words, multiply by 100 percent minus the percentage you want to subtract, in decimal form. To subtract 20 percent, multiply by 80 percent (0.8).

How do you take 15% off in Excel?

Tip: You can also multiply the column to subtract a percentage. To subtract 15%, add a negative sign in front of the percentage, and subtract the percentage from 1, using the formula =1-n%, where n is the percentage. So to subtract 15% use =1-15% as the formula.

How do you calculate a Class 8 discount?

You can find the discount by subtracting its sale price from its marked price. So, Discount = Marked price – Sale price.

How do you subtract 40% from a price?

Fraction Off Price Formula

  1. Multiply list price by the fraction discount: 120*1/3 = 40.
  2. Subtract discount amount from list price: 120 – 40 = 80.
  3. With the formula: 120 – (120*1/3) = 120 – 40 = 80.
  4. 1/3 off $120 is $80.