I'd like a formula in the ABCD column that reads the percentage and
displays A or B or C or D based on the requirements below

A column identifying the sales history A B C D E

"A" ranked products responsible for 80% of sales
"B" ranked products responsible for 15% of sales
"C" ranked products responsible for 4% of sales
"D" ranked products responsible for 1% of sales

5. I'd also like to see how the listing below is expressed.

First 40%, cumulative 40% are "A" items
Second 40% cumulative 80% are "B" items
Next 15% cumulative 95% arer "C" items
Next 4% cumulaitive 99% are "D" items
Last 1% cumulative 100% are "E" items

I'd like a formula in the ABCD column that reads the percentage and
displays A or B or C or D


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=514172