FinanceTier 1212 minintermediate

Cap a Purchase Order Against Remaining Budget

Restrict a purchase order amount so it can never exceed the budget remaining in another cell.

What you will learn

• Write a custom data validation formula that references another cell
• Explain why a limit tied to a live cell stays correct as that cell changes
• Recognise a hard-coded limit as a trap that goes stale

Excel skills

Data Validation - Custom Formula · Data Validation

The task

Purchase order requests in column A must never exceed the amount actually remaining in the budget, shown in B4. Add a custom validation rule to column A that checks each request against that live cell - not a fixed number.

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