Flag stock for reorder
Flag an item when on-hand quantity reaches or falls below its reorder point.
Copyable formulas
English Excel · en-US
=IF(AND(B2<>"",C2<>""),IF(B2<=C2,"Reorder","Sufficient"),"")Turkish Excel · tr-TR
=EĞER(VE(B2<>"";C2<>"");EĞER(B2<=C2;"Sipariş ver";"Yeterli");"")Sample data
Enter the headers and sample records in A1:C5.
| Item | On hand | Reorder point |
|---|---|---|
| Cable | 10 | 10 |
| Socket | 12 | 5 |
| Switch | 0 | 4 |
| Fuse | 6 |
Fill down through D5. Enter quantities as numbers.
Enter the formula in D2.
To try the Turkish formula, use the sample data on the Turkish page.
Expected result
Reorder, Sufficient, Reorder, blank
How it works
Equality triggers a reorder. Numeric zero is a valid stock level. If either quantity or threshold is missing, the output stays blank. This flags the need to reorder. Order quantity is a separate calculation.
Compatibility
Excel for Microsoft 365 and Excel 2016, 2019, 2021, and 2024.