I am trying to figure a discount based on a count
 

I am trying to formulize a discount based on a count:
2 <6 5% - 5 <12 10% =12 12 15%
The formula I try doesn't tell me it has an error, but it only calculated
the first condition?
Any Ideas?

Thanks

I am trying to figure a discount based on a count
 

Try this formula in cell B1:

=(A12)*5%+(A15)*5%+(A111)*5%


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=538752