Excel

PRICEDISC: Excel Formulae Explained

How do you use PRICEDISC in Excel?

Pricedisc is used in excel to find the price of a product after discounts. You can use it to find the original price, the discounted price and the percentage of the discount.

What is the syntax of PRICEDISC in Excel?

The syntax for PRICEDISC in Excel is as follows:

=PRICEDISC(cost,discount)

This function calculates the discounted price of a product based on the cost and the discount.

What is an example of how to use PRICEDISC in Excel?

PRICEDISC is a function in Excel that calculates the price discount for a given quantity. The function takes three arguments: the quantity, the original price, and the discount percentage. The function will return the discounted price for the given quantity. An example of how to use the PRICEDISC function in Excel is shown below:

=PRICEDISC(10,100,10)

This function will return the discounted price for 10 items at 100 dollars each, which is 90 dollars.

When should you not use PRICEDISC in Excel?

There are a few occasions when you should not use PRICEDISC in Excel. One such occasion is when you are working with text values. In this instance, you should use the VLOOKUP function instead. Another time you should not use PRICEDISC is when you are working with arrays.

What are some similar formulae to PRICEDISC in Excel?

The PRICEDISC function in Excel is used to calculate the price per unit of a discounted product. It takes the discounted price, the original price, and the number of units as input and calculates the price per unit. There are a few other similar formulae in Excel that can be used to calculate prices. The PERCENTDISC function calculates the percentage of a discount on a product. The VLOOKUP function can be used to find the price of a product given the discounted price and the original price. The RATE function can be used to calculate the interest rate on a loan.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.