Col A Col B Col C Col D
Row 1 Price % Disc Disc Amt Disc Price
Row 2 100.00 30.0% 30.00 70.00
Row 3 200.00 30.0% 60.00 140.00


in C2, use "=A2*B2", and in D2, use "=A2-C2"


"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


Les