Check Missing Grades
A Gradebook Admin needs to quickly identify which students have a missing grade in their records. If the 'Grade' column is empty for a student, the system should flag it as 'Missing Grade', otherwise, it should display 'Grade Entered' to confirm completion.
=IF(C2="", "Missing Grade", "Grade Entered") How it works: This formula uses the IF function to perform a logical test. It checks if the cell in the 'Grade' column (C2 in this example) is empty (`C2=""`). If the condition is TRUE (the cell is empty), it returns 'Missing Grade'. If the condition is FALSE (the cell contains a grade), it returns 'Grade Entered'. This provides an immediate visual status for each student's grade record.
Data Setup
| Student Name | Subject | Grade |
|---|---|---|
| Alice Smith | Math | 85 |
| Bob Johnson | Science | |
| Charlie Brown | History | 92 |
| David Lee | Art | |
| Eve Davis | English | 78 |
Step-by-Step Guide
Identify the column containing the grades (e.g., Column C for 'Grade').
In an adjacent empty column (e.g., Column D), enter the formula `=IF(C2="", "Missing Grade", "Grade Entered")` for the first student's row (assuming headers are in row 1, data starts in row 2).
Press Enter to see the result for the first student.
Drag the fill handle (the small square at the bottom-right of the selected cell) down to apply the formula to all other student rows.
Review the results in Column D to quickly see which students have 'Missing Grade' and require follow-up.