Creating Remarks from grades

Closed
Ssysie - Aug 19, 2016 at 09:09 AM
Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 - Aug 19, 2016 at 10:16 AM
How do I create corresponding remarks against letter grades?

1 reply

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Aug 19, 2016 at 10:16 AM
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
0