If you maintain inventory in an Excel worksheet, you probably need to know when stock runs low so you can reorder. Fortunately, you can let Excel warn you when an item is running low by applying a ...

How to Set a Low Inventory Alert in Excel. ... on the left under Condition1 and select "Formula is." ... in the actual inventory cell whenever your logged inventory slips below your reorder level.

The number you get from this calculation is known as your safety stock number. Find Your Critical Inventory Number The formula for your critical inventory number is (Order quantity + Safety stock)/2.