I've attached a copy of the template. What I'm looking to do is add the ability to deduct sale amounts.
Can I add a column between "cost per unit" and "amount" that will calculate a 15%, 20% or 25% discount to the individual items?
I know how to add a column but not how to make it do what I want it to do! I don't use Excel enough to know all the functions. I only know basics.
Any help would be greatly appreciated.
Doreen