Trigger Reorder Alert
I need a formula that displays 'Order Now' if the quantity in stock is less than 10, otherwise displays 'Stock OK'.
=IF(B2<10, "Order Now", "Stock OK") How it works: This formula uses the IF function to perform a logical test. `B2<10` checks if the quantity in stock (cell B2) is less than 10. If this condition is TRUE, the formula returns 'Order Now'. If the condition is FALSE (meaning the quantity is 10 or more), it returns 'Stock OK'. This provides an immediate visual alert for items requiring attention.
Data Setup
| Product ID | Quantity in Stock |
|---|---|
| P001 | 15 |
| P002 | 5 |
| P003 | 20 |
| P004 | 9 |
| P005 | 10 |
Step-by-Step Guide
Open your Excel spreadsheet containing your inventory data.
Identify the column with 'Quantity in Stock' (e.g., Column B).
Select the first empty cell in the row where you want the reorder status to appear (e.g., C2, assuming your data starts from row 2).
Type the formula: `=IF(B2<10, "Order Now", "Stock OK")`
Press Enter. The cell will now display 'Order Now' or 'Stock OK' based on the quantity in B2.
Drag the fill handle (the small square at the bottom-right corner of cell C2) down to apply the formula to the rest of your inventory items.
Explore More
Identifying Supplier Contact Persons
As an Inventory Manager, I frequently need to contact suppliers regarding stock levels, new orders, or delivery issues. I have a list of suppliers with their unique IDs, but often need to quickly find the specific contact person for a given supplier (e.g., from cell E2). Manually searching through a large supplier list is inefficient and can delay critical communications.
Extracting All Details for a Specific Item
An Inventory Manager needs to quickly retrieve all associated details (Description, Quantity, Location) for a specific Item ID. Manually copying and pasting multiple cells for each item is tedious and error-prone, especially when managing a large catalog.
Find Stock Level by SKU
I need to look up the current stock quantity for a specific product SKU from a large inventory table.
Categorize Products by SKU Prefix
I need to extract the first 2 letters of an SKU (e.g., 'FU' from 'FU-101') to determine the product category (Furniture).