EXCEL DISCOUNT FORMULA wrote:
I am trying to create a price list subject to a discount.

I need the formula in order to issue a nett price list


Regards


Hi Les,

If DiscountRate is a decimal value (e.g., 30% discount = 0.3),

= Price * (1 - DiscountRate)