FinanceTier 1215 minadvanced

Require Each Ledger Balance to Exceed the One Above It

Add a custom validation rule so a cumulative ledger balance can never go backwards.

What you will learn

• Write a custom data validation formula comparing an entry to the cell above it
• Explain why a positive-number check alone allows a balance lower than the previous one
• Apply a row-relative validation rule down a column

Excel skills

Data Validation - Custom Formula (Row Comparison) · Data Validation

The task

A cumulative ledger balance can only ever go up. The first balance (165479) is already logged in row 2. Add a custom validation rule to the balances below it so each new entry has to be greater than the one directly above it.

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