Administration and Executive AssistantTier 1212 minintermediate

Cap a Request Against a Live Budget

Restrict an entry so it can never exceed the amount 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

Petty cash float requests in column A must never exceed the amount actually remaining in the float, shown in B5. 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