Forum

Notifications
Clear all

[Solved] Formula for number grading students report

3 Posts
2 Users
0 Reactions
312 Views
(@santy)
Posts: 2
New Member
Topic starter
 

I'm trying to generate grades for my students but keep getting a FALSE in some cells. I can't identify the challenge. The number grades used by my school is as follows:

90-100 = 1

80-89 = 2

70-79 = 3

60-69 = 4

55-59 =5

50-54 =6

45-49 =7

40-44 = 8

39 -0 = 9

Please, help. Thank you

 
Posted : 26/01/2025 8:06 am
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

See the attached file that uses a Vlookup function

 

 
Posted : 26/01/2025 9:18 am
(@santy)
Posts: 2
New Member
Topic starter
 

Thank you!

 

 
Posted : 27/01/2025 8:25 pm
Share: