 2
Thanks

A few words of thanks would be greatly appreciated.

# Prepare Grades from Marks on Excel

Mathematical and logical operations can be performed on a Microsoft Excel workbook with the help of formulas. One of the most common uses of Excel is to compare rows of data by using an IF statement. When applied, this function can be used in an array of professional situations, from finding errors in extensive company financial statements to preparing student grades from marks. ## How To Grade Using Excel

Let's take an example whereby a teacher needs to grade each student with a certain letter that corresponds to the numeric value received on an exam. All number grades are input into column A, and all letter equivalents need to be quickly calculated and shown in column B. The grading scale is as follows:

`80-100=A    60-79=B    50-59=C    40-49=D    30-39=E    0-29=F`

Using this information, we can build a compound IF function to find the correct letter associated with the grade:

`=IF(A1<=29,"F",IF(A1<=39,"E",IF(A1<=49,"D",IF(A1<=59,"C",IF(A1<=79,"B","A"))))) `

In this formula, you will notice that every letter grade is associated with a condition that accounts for each range of numbers. The FALSE value is A, meaning that if none of the criteria in the equation are met, the student should be given an "A".

Note that the cell reference and condition may be tweaked to suit specific ranges as well as cell areas.

Image: © Dzmitry Kliapitski - Shutterstock.com
2
Thanks

A few words of thanks would be greatly appreciated.

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
Related
This document, titled « Prepare Grades from Marks on Excel », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net). 