Letter code based on another cell

[RSnap3232]

hello All

was wondering how can I go about getting a cell to populate with the below letters based on a percentage in another cell;

0% = R
1% to 49% = R+
50% to 99% = A
100% = G
blank = G+

Site	Coached	Non Coached	Total	% Compliant	Code
site 1	10​	1​	11	91%​	A

 

[Micron]

You didn't say if you want a formula solution or vba code, or if either would do. I'm not great at formulas but something like this worked in my testing where AR6 contains a value that is within the ranges you posted:
=IF(AR6=0,"R",IF(AND(AR6>0,AR6<50),"R+",IF(AND(AR6>49,AR6<100),"A",IF(AR6=100,"G",IF(AR6=-1,"G+")))))

However, you would have to use numbers and not text, which means a blank cell will return the wrong value. I used -1 instead of an empty cell and the cell is formatted as a number. Perhaps nesting Isblank function could work with empty cells but I don't have time to try it right now.

 

[Snakehips]

Another possible approach?

Testing Formula Update.xlsm
	E	F
1	%Comp;iant	Code
2	0%	R
3	15%	R+
4	49%	R+
5	50%	A
6	72%	A
7	99%	A
8	100%	G
9		G+
10	1%	R+
11	Random text
12	101%
Sheet2

Cell Formulas
Range	Formula
F2:F12	F2	=IFERROR(IF(E2="","G+",LOOKUP(E2,{0,"R";0.01,"R+";0.49,"R+";0.5,"A";1,"G";1.01,""})),"")

 

[RSnap3232]

=IFERROR(IF(E2="","G+",LOOKUP(E2,{0,"R";0.01,"R+";0.49,"R+";0.5,"A";1,"G";1.01,""})),"")

that is brilliant worked exactly how i needed cheers for the responses