Check Wind Speed Safety
As a crane operator, I need to quickly determine if current 'Wind Speed' exceeds 20 mph. If the wind speed is greater than 20 mph, I need an immediate alert to 'STOP OPERATIONS'; otherwise, I should see 'PROCEED' to continue work safely.
=IF(B2>20,"STOP OPERATIONS","PROCEED") How it works: The IF function evaluates a logical test. In this case, `B2>20` checks if the wind speed in cell B2 is greater than 20. If this condition is TRUE (wind speed is above 20 mph), the formula returns "STOP OPERATIONS". If the condition is FALSE (wind speed is 20 mph or less), it returns "PROCEED". This provides an instant, clear safety status for each recorded wind speed.
Data Setup
| Date | Wind Speed (mph) | Safety Status |
|---|---|---|
| 2023-10-26 08:00 | 15 | |
| 2023-10-26 09:00 | 22 | |
| 2023-10-26 10:00 | 18 | |
| 2023-10-26 11:00 | 25 | |
| 2023-10-26 12:00 | 19 |
Step-by-Step Guide
Open your Excel worksheet containing the wind speed data.
Assume your 'Wind Speed (mph)' data starts in cell B2.
Select cell C2 (or any empty cell in the same row where you want the safety status to appear).
Type the formula: `=IF(B2>20,"STOP OPERATIONS","PROCEED")`
Press Enter. Cell C2 will now display either 'STOP OPERATIONS' or 'PROCEED' based on the wind speed in B2.
Drag the fill handle (the small square at the bottom-right corner of cell C2) down to apply this formula to all other rows with wind speed data.