**Contents**show

## How do you calculate price before discount in Excel?

Excel allows a user to calculate an original price from percentage discount using a simple formula.

…

Calculating the Original Price without Discount

- Select cell D3 and click on it.
- Insert the formula: =B3/(1-C3)
- Press enter.

## What is the formula to calculate discount in Excel?

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.

## How do you take 20% off a price in Excel?

If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of. For example, if you want to calculate 20% of 500, multiply 20% by 500. – which gives the result 100.

## How do you find the pre discount price?

How do I calculate the price before discount?

- First, divide the discount by 100.
- Subtract this number from 1.
- Divide the post-sale price by this new number.
- Here you go, that’s the original price before the applied discount.

## What is the formula to calculate discount?

The formula to calculate the discount rate is: Discount % = (Discount/List Price) × 100.

## How do you calculate 15 discount in Excel?

To subtract 15%, use =1-15% as the formula.

…

Here’s how to do it:

- Enter the numbers you want to multiply by 15% into a column.
- In an empty cell, enter the percentage of 15% (or 0.15), and then copy that number by pressing Ctrl-C.
- Select the range of cells A1:A5 (by dragging down the column).

## How do you take 50 off in Excel?

If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of. For example, if you want to calculate 25% of 50, multiply 25% by 50.