Administration and Executive AssistantTier 215 minbeginner

Reorder Points with IF

Decide each morning what to order: on hand plus on order against the reorder point.

What you will learn

• Compare on hand plus on order with the reorder point
• Use <= so an item exactly on its reorder point is ordered
• Count the items to order with COUNTIF

Excel skills

IF, comparison operators, COUNTIF · Conditional Logic

The task

I place stock orders every morning. For each item on the Stock tab, write "Reorder" in column F when what we have plus what is already on order is at or below the reorder point, and "OK" otherwise. Then put the number of items to reorder on the Summary tab.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free