Percentage Range

[OneDudeIntheCarib]

Hello, I haven't used Excel since 2009 and the version so I very rusty but I know how to calculate percentage which was pretty easy to remember but at the moment i have a project to get done and i stuck, I don't seem to remember if you can do percentage range and how to calculate it, most i remember is using the IF function but how do i tie the percentage to those categories and how do i calculate the percentage range?

Legendary- 1% or lower
Epic- 1.01% - 3%
Rare- 3.01% - 10%
Uncommon- 10.01% - 20%
Common- 20.01% +
This would obvious add up to 100% and exact and it would be calculated from a supply of 3333 but for the life of me can't remember and the only info was from this site but still wasn't enough, any help would be appreciated thanks

 

[AhoyNC]

Is this what you are trying to do?

Book2
	A	B
1	6.8%	Rare
Sheet1

Cell Formulas
Range	Formula
B1	B1	=IF(A1<=1%,"Legendary",IF(A1<=3%,"Epic",IF(A1<=10%,"Rare",IF(A1<=20%,"Uncommon","Common"))))

 

[Toadstool]

Hi OneDudeInTheCarib,

If you want assistance with calculating the percentage can you give examples and maybe a simple expected result?

To generate the legends try this:

OneDudeInTheCarib.xlsx
	F	G	H
1	Percent		Legend
2	-999.00%		Legendary
3	0.10%		Legendary
4	1.00%		Legendary
5	1.01%		Epic
6	3.00%		Epic
7	3.01%		Rare
8	4.00%		Rare
9	10.00%		Rare
10	10.01%		Uncommon
11	20.00%		Uncommon
12	20.01%		Common
13	99.00%		Common
14	9999.00%		Common
Sheet1

Cell Formulas
Range	Formula
H2:H14	H2	=CHOOSE(MATCH(F2,{-999,0.0101,0.0301,0.1001,0.2001,9999},1),"Legendary","Epic","Rare","Uncommon","Common")

 

[OneDudeIntheCarib]

Ah okay yes, this is exactly what i was looking for thank you very much.