I am having trouble with excel discount functions?

$1.50 each

$7.50 for six = $1.25 each

$15.00 for twelve = $1.25 each

So: "= if(qty < 6, qty * $1.50, qty * 1.25)"

where qty is the quantity ordered cell.

or, if you were going t have a different price foe each at a dozen:

"= if(qty > 11, qty * up12,if (qty > 5,qty*up6, qty *up1))"

where up12 = unit price at 12, up6 = unit price at 6, up1 = unit price for each

Call this price.

and the discount "= up1*qty - price"

If you want to charge out at the discounted price for even dozens or half-dozens, and full price for the singles, something similar would work, except that you'd do something to qty in the calculation.

If you want it within one formula, it gets ugly.

Use the formula:

=(INT(A1/12)*PricePerDozen)+

(INT((MOD(A1-INT(A1/12)*12,12)/6))*

PricePerHalfDozen)+

(A1-(INT(A1/12)*12)-

(INT((MOD(A1-INT(A1/12)*

12,12)/6))*6))*PricePerEach

I had to split the lines so that it would not get truncated.

I also assume you would want to define cell names (ex. PricePerEach) for the prices so that if you change your prices you don't have to change the formulas.

It is cleaner if you use hidden cells to individually calculate the number of even dozens, half dozens, and then eachs.

The discount is simply the total qty * PricePerEach minus the value calculated above.

It's too complicated for a small business. It needs a conditional format and is difficult. Why would you want to piss off a good customer who wants to 35?