If you wanted to deduct a percentage from a price you could use something
similar to the following formula.

Say you have a price of £100 in cell B2 and you want to display this price
minus 20% you would use the formula =B2-(B2/100*20).

This would give you the value after subtracting 20% from the original, in
this case £80. For different %'s just change the 20 figure in the brackets to
whatever percentage you require. By using the cell reference in the forumla
this will automatically change dependant on what value is entered into B2.

"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