answersLogoWhite

0

The VLOOKUP function would be the best one to use. You need to set up a table with the name of the grade and the range of marks for that grade. You then compare each score against the range in the table and it will read off the apporpriate grade. Do some research on the VLOOKUP function and that will help.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

How do you use taxon in a sentence?

The students had difficulty assigning the creature to an appropriate taxon.


Would this way of assigning roles be an example of a function if there are 20 students and 20 available roles and each student is assigned exactly one role in the play to be played by only one student?

Yes, it would.


What percentage of students in my class are failing?

The percentage of students in your class who are failing is 20.


What is the percentage of students are male?

It is not specified how many students there are in total, so it is not possible to calculate the percentage of male students without that information.


What has the author James S Terwilliger written?

James S. Terwilliger has written: 'Assigning grades to students' -- subject(s): Educational tests and measurements, Grading and marking (Students)


If Randomly assigning students to two different groups in an experiment on memory would be?

An important measure for controlling bias (APEX)


What percentage of college students are non-traditional students?

89 percent


What percentage of students change their mind about college during a gap?

the percentage of students change their mind about college during a gap is 50%


How many students bring in a weapon each year?

what percentage of students bring drugs to school each yearwhat percentage of students bring weapons to school each year


What percentage of students who go to college successfully graduate?

The percentage of college students who successfully graduate varies, but on average, about 60 of students who start college end up graduating.


What is the function of students in education?

Students are the consumers of an enterprise called the education.


What is the function of classroom?

the function of a classroom is to hold the students, so they can learn