Check Bus Capacity
A Bus Coordinator needs to quickly identify which bus routes have a 'Student Count' that exceeds the 'Bus Capacity' to arrange alternative transport or adjust routes.
=IF(B2>C2, "Over Capacity", "Within Capacity") How it works: This IF function checks a logical condition: whether the value in the 'Student Count' cell (B2) is greater than the value in the 'Bus Capacity' cell (C2). If the condition is TRUE, it returns 'Over Capacity', indicating a potential issue. If the condition is FALSE (meaning student count is less than or equal to capacity), it returns 'Within Capacity'. This allows the Bus Coordinator to instantly see which buses require attention for safety and logistical planning.
Data Setup
| Bus ID | Student Count | Bus Capacity |
|---|---|---|
| B001 | 45 | 50 |
| B002 | 55 | 50 |
| B003 | 30 | 40 |
| B004 | 60 | 60 |
| B005 | 48 | 45 |
Step-by-Step Guide
Open your Excel spreadsheet containing bus data with 'Bus ID', 'Student Count', and 'Bus Capacity' columns.
Select the first empty cell in the row where you want the capacity status to appear (e.g., D2, assuming headers are in row 1).
Enter the formula: `=IF(B2>C2, "Over Capacity", "Within Capacity")`
Press Enter. The cell will display 'Over Capacity' if the student count exceeds capacity, or 'Within Capacity' otherwise.
Drag the fill handle (the small square at the bottom-right of the selected cell) down to apply the formula to all other bus routes.