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