Check GPA Requirement
The Scholarship Committee needs to quickly identify which applicants meet the minimum GPA requirement of 3.5 to be considered for a scholarship. They want to mark applicants as 'Eligible' or 'Not Eligible' based on their reported GPA.
=IF(B2>=3.5,"Eligible","Not Eligible") How it works: The IF function checks a logical condition. If the condition (GPA >= 3.5) is TRUE, it returns the first specified value ('Eligible'). If the condition is FALSE, it returns the second specified value ('Not Eligible'). This allows the Scholarship Committee to automate the initial screening process, saving significant time and ensuring consistent application of the GPA criterion.
Data Setup
| Applicant Name | GPA | Eligibility Status |
|---|---|---|
| Alice Smith | 3.8 | |
| Bob Johnson | 3.2 | |
| Charlie Brown | 3.9 | |
| Diana Prince | 3.5 | |
| Eve Adams | 3.1 |
Step-by-Step Guide
Open your scholarship applicant data in Excel.
Locate the column containing the 'GPA' for each applicant (e.g., Column B).
In an empty column (e.g., Column C), type the formula `=IF(B2>=3.5,"Eligible","Not Eligible")` into the first applicant's row (e.g., C2).
Press Enter. The cell will display 'Eligible' or 'Not Eligible' based on the GPA in B2.
Drag the fill handle (the small square at the bottom-right of cell C2) down to apply the formula to all other applicants.