Check Graduation Eligibility
An academic advisor needs to quickly identify which students are eligible for graduation based on their 'Credits Earned'. The rule is: If 'Credits Earned' is greater than or equal to 120, the student is 'Eligible'; otherwise, they are 'Not Eligible'.
=IF(B2>=120, "Eligible", "Not Eligible") How it works: This formula evaluates a logical test: `B2>=120`. If the student's credits (in B2) are 120 or more, the test is TRUE, and the formula returns 'Eligible'. If the credits are less than 120, the test is FALSE, and the formula returns 'Not Eligible'. This provides an immediate status for each student.
Data Setup
| Student Name | Credits Earned | Graduation Status |
|---|---|---|
| Alice Smith | 125 | |
| Bob Johnson | 110 | |
| Charlie Brown | 130 | |
| Diana Prince | 90 | |
| Eve Davis | 120 |
Step-by-Step Guide
Open your student data spreadsheet in Excel.
Locate the column containing 'Credits Earned' (e.g., Column B).
In an empty column (e.g., Column C), in the first data row (e.g., C2), type the formula: `=IF(B2>=120, "Eligible", "Not Eligible")`.
Press Enter to see the result for the first student.
Drag the fill handle (the small square at the bottom-right of cell C2) down to apply the formula to all other students in your list.