**Contents**show

## What is the formula to calculate discount?

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

## How do you calculate direct discount percentage?

The basic way to calculate a discount is to multiply the original price by the decimal form of the given percentage rate.

## How is discount calculated in India?

For example, you may want to calculate the sale price of a shirt that regularly costs Rs 1,000. If the shirt is 20% off, you must convert 20% to a decimal (20/100 = 0.2). You have Rs 1,000 * 0.2 = Rs 200. You then subtract the discount from the original price as Rs 1,000 – Rs 200 = Rs 800.

## How do you calculate 15 off 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).