The Problem
Stock tables can look fine until one location quietly drops too low. An item may still have quantity somewhere, but if either the shelf or the warehouse is near empty, the team needs to know before it turns into a stockout.
This challenge is built around that kind of early warning. We check two stock columns, flag the rows that need attention, and then summarize how many products are in the list and how many need reordering.
How We Solve It
The main rule is simple. A row should say REORDER if shelf stock is below 5 or warehouse stock is below 10. Since either condition is enough, OR is the right helper.
Method 1: IF with OR
Method 1: Flag the row when either stock location drops below its threshold.
This is the method the challenge expects. OR checks both thresholds, and IF turns the result into a readable status. If either location is too low, the formula returns REORDER. Otherwise it returns OK.
This solves the actual stock problem because a shortage in either location is enough to create risk. The formula does not wait for both numbers to be low. It flags the row as soon as one side drops past its threshold.
=IF(OR(B2 < 5, C2 < 10), "REORDER", "OK")
Method 2: Use MIN to spot the weakest point
Method 2: Focus on the weakest stock point across two locations.
If your rule is based on the smallest number across locations, MIN is a clean shortcut. It is not the validator pattern here, but it is useful when the business only cares about the lowest available quantity regardless of where it sits.
This solves a slightly different inventory problem, where the weakest stock point drives the decision by itself. It is useful when the two locations are treated as one combined supply risk instead of having separate thresholds.
=IF(MIN(B2:C2) < 5, "CRITICAL", "STABLE")
Method 3: Grade stock with IFS
Method 3: Use several labels when you want more detail than one reorder flag.
Sometimes one alert is not enough. IFS can create levels such as out of stock, low, and healthy. That gives more detail to planners, even though this challenge keeps the final output to just REORDER or OK.
This solves the planning problem when the team needs more than a yes-or-no warning. It turns one stock check into a clearer status scale, which can help decide which items need urgent action first.
=IFS(B2=0, "OUT", B2<5, "LOW", TRUE, "GOOD")
Function Explanation
1. OR
OR returns TRUE if at least one condition is true. That fits this stock rule perfectly because a problem in either location should trigger the alert.
Learn more this functionOR
2. IF
IF converts the logical test into the visible label the team will actually read. It is what turns TRUE and FALSE into REORDER and OK.
Learn more this functionIF
3. COUNTIF
COUNTIF finishes the worksheet by counting how many rows ended up with the reorder label. That gives a quick summary without scanning the whole table again.
In a real inventory file, the thresholds may vary by product. This challenge uses fixed rules so the formula stays focused on the logic pattern itself.
Check each stock row against the shelf and warehouse thresholds, mark the items that need reordering, and then finish the summary so the worksheet shows the total number of SKUs and how many were flagged.