Determine Character from Certain Value in Ms Excel

Iskandar Blogger 4:54 PM

Title of this post means : if you have a table from a list of values In Ms Excel such as Test Scores, and you want to convert those values to character A, B, C, D or E in other Cells automatically without have to type it manually one by one, you can use IF Function

For example, the definition :

Value	Using character
0-59	E
60-74	D
75-84	C
85-94	B
95-100	A