Creating Remarks from grades

[Closed]
Report
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
How do I create corresponding remarks against letter grades?

1 reply

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
Ssysie, Good morning.

You can create a little table and use a VLOOKUP function.

Scenario:
.........D....|......E..........
1.......A....|....Remark 1
2.......B....|....Remark 2
3.......C....|....Remark 3
4.......D....|....Remark 4
5.......E....|....Remark 5

A1 --> GRADE --> B

B1 --> =VLOOKUP( A1, D1:E5, 2, FALSE )
B1 --> Remark 2

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão