Check Weight Class
A sports coach needs a quick and automated way to categorize athletes into different weight classes (e.g., 'Lightweight' or 'Heavyweight') based on a specific weight threshold. Manually checking each athlete's weight and assigning a class is time-consuming and prone to errors, especially with a large roster. The coach wants to automatically assign 'Lightweight' if an athlete's weight is less than 150 lbs, and 'Heavyweight' otherwise.
=IF(B2<150,"Lightweight","Heavyweight") How it works: This formula checks the weight value in cell B2. If the weight is less than 150, the formula returns 'Lightweight'. Otherwise (if the weight is 150 or greater), it returns 'Heavyweight'. This allows the coach to quickly sort and filter athletes by their assigned weight class, streamlining team management, competition planning, and ensuring fair matchups.
Data Setup
| Athlete Name | Weight (lbs) | Weight Class |
|---|---|---|
| John Doe | 145 | Lightweight |
| Jane Smith | 160 | Heavyweight |
| Mike Johnson | 130 | Lightweight |
| Sarah Lee | 155 | Heavyweight |
| Chris Evans | 149 | Lightweight |
Step-by-Step Guide
Enter your athlete data into an Excel sheet. Place 'Athlete Name' in column A and 'Weight (lbs)' in column B, starting from row 2.
In cell C2 (or the first cell of your desired 'Weight Class' column), type the formula: `=IF(B2<150,"Lightweight","Heavyweight")`
Press Enter to apply the formula to the first athlete.
Drag the fill handle (the small square at the bottom-right corner of cell C2) down to apply the formula to all other athletes in your list.