Assign Letter Grades Based on Score
I want to automatically assign 'A', 'B', 'C', or 'F' based on the numeric score in the adjacent cell.
=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C","F"))) How it works: This formula uses nested IF statements to check conditions sequentially. It first checks if the score in B2 is 90 or above; if true, it assigns 'A'. If false, it moves to the next IF, checking if the score is 80 or above for 'B', and so on. The conditions are ordered from highest to lowest, ensuring that a score of 95 correctly receives an 'A' before being evaluated against the '>=80' condition. The final 'F' catches all scores below 70. This automates the grading process, saving time and ensuring consistent application of grading criteria.
Data Setup
| Student Name | Score |
|---|---|
| Alice | 92 |
| Bob | 85 |
| Charlie | 73 |
| David | 68 |
| Eve | 95 |
| Frank | 79 |
| Grace | 81 |
| Heidi | 62 |
Step-by-Step Guide
Open your Excel spreadsheet containing student scores. Assume scores are in column B, starting from cell B2.
In cell C2 (or any adjacent empty cell where you want the grade to appear), enter the following formula: `=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C","F")))`
Press Enter to see the letter grade for the first student.
Drag the fill handle (the small square at the bottom-right corner of cell C2) down to apply the formula to all other student scores in column B.
Explore More
Count Students Who Passed the Exam
I need to quickly count how many students scored above 60 in the final math exam.
Retrieve Student Guardian Contact Info
I have a student ID in one sheet and need to pull their guardian's email address from the school registry.
Combine First and Last Names for Roster
I have student first names in column A and last names in column B and need to merge them into 'Last, First' format.
Sum Points for Specific Assignment Type
As a teacher, I want to calculate the total points earned across all students specifically on 'Homework' assignments, ignoring other assignment types like quizzes or exams. This helps me track overall progress for a particular category of work.