Check Completion Status
As an online course creator, I need a quick way to see if a student has completed all modules in a course. If 'Modules Completed' equals 'Total Modules', I want to mark them as 'Completed'; otherwise, they are 'In Progress'.
=IF(B2=C2,"Completed","In Progress") How it works: This formula evaluates a logical test: `B2=C2`. If the number of modules completed (B2) is equal to the total number of modules (C2), the condition is TRUE, and the formula returns 'Completed'. If they are not equal, the condition is FALSE, and the formula returns 'In Progress'. This provides an automated status update for each student.
Data Setup
| Student Name | Modules Completed | Total Modules | Completion Status |
|---|---|---|---|
| Alice | 5 | 5 | |
| Bob | 3 | 5 | |
| Charlie | 5 | 5 | |
| David | 2 | 5 |
Step-by-Step Guide
Open your course progress tracking spreadsheet in Excel.
Identify the columns containing 'Modules Completed' (e.g., Column B) and 'Total Modules' (e.g., Column C).
In the first cell of your 'Completion Status' column (e.g., D2), type the formula: `=IF(B2=C2,"Completed","In Progress")`.
Press Enter to apply the formula to the first student's row.
Drag the fill handle (the small square at the bottom-right of cell D2) down to apply the formula to all other student rows.