ExcelFlux

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.

Microsoft Excel reference