Toatal = price - (price-%age discount)

=100-(100*.1) = 90

=B1-(B1*C1)


Gord Dibben MS Excel MVP


On Sat, 28 Mar 2009 09:30:01 -0700, knitsteel
wrote:

I need a sales invoice template that will calculate a percent discount off
the item price. So I want it to have a field for quantity, price, %discount,
then total. All of the ones that I've seen which show discount are for a
discount that I have to calculate and enter myself.