Don't know if it is protected or not but assume that the discount is in H6
and the price before shipping in G6 then you can use

=G6*(1-H6)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"wambui" wrote in message
...
Hello!

I am very new to Excel and have downloaded a Sales Invoice Template (not
sure what it is called).

I have fields in this template for:
Quantity
Unit Price
Total
(going accross template)
Then at the bottom there are these fields:
Sub Total
Shipping
Tax Rate
TOTAL
What I would like is to have a Percentage Discount field for a $50%
discount
before the shipping field.

Is there a way to do this and how can I do it.

Thanks!