Hi there
I've been trying to create a spreadsheet for a holiday shop and I've gotten nowhere in 2 hours.
I need these columns and will have almost 200 items
item, qty, total cost, cost each, 40% disc cost each, price, count, sold, profit
I know the Qty and the total cost and will input the price we charge and then count after the sale is over. I would like the cost before and after the 40% disc and then figure out a formula for the amount sold and the profit.
the problem was I was trying to calculate the cost for each widget using QUOTIENT but it was giving me $3.00. My calculator gives me $3.35.
I am going to go back and look at the autosum for the sold column but I can't seem to be able to figure out cost per piece much less the disc or profit
I would appreciate any help with this.
thanks
g
Bookmarks