Stockertim Dictionary · Artificial intelligence · Technology
Formula test sheet
Also called formula test sheets, test sheet, test tab
In short
A small, separate sheet of made-up rows, each with its correct result worked out by hand, used to try a new or AI-drafted formula before it touches real data.
- Beginner
- Document
- Checked
In detail
A formula test sheet is a controlled place to prove a formula works. It holds a handful of invented inputs, an expected result for each one worked out independently, a column where the new formula runs, and a pass or fail column such as =IF(C2=D2,"Pass","Fail"). Only when every row passes is the formula copied into the working sheet.
The rows are chosen to probe the rule, not to look like average data. A good set includes an ordinary case in each band, values exactly on every threshold, values just either side of each threshold, a zero, a blank, a negative if one could occur, and a text entry where a number is expected. For a tiered bonus, that might mean amounts of 150, 199, 200, 201, 399, 400 and 0.
The method matters most for formulas drafted by AI assistants. A language model produces formulas that look right and usually run without errors, yet small slips such as > instead of >=, a band tested in the wrong order or a misplaced bracket only show on particular inputs. Because the test data is made up, no personal or confidential data needs to be shared with the assistant, and the test can be rerun when the formula is changed later.
Keeping the sheet in the workbook leaves evidence for a reviewer: what was tested, with which values, and the result. Expected answers must be worked out by hand or by a separate method, never by the formula under test, or the test proves nothing.
Worked example
A sales manager in Nottingham asks an AI assistant for a bonus formula: 3% from 200, 5% from 400. The test sheet has 6 rows.
- Expected for 200: 200 × 3% = 6; the drafted formula returns 0, so the row fails
- Expected for 400: 400 × 5% = 20; the formula returns 12, another failure
- The cause is > used where the rule says "from"; after changing to >=, all 6 rows pass
Two boundary rows exposed an error that ordinary sales figures would rarely have shown.
In practice
Analysts and finance staff keep a test tab for any formula with conditions, thresholds or lookups, especially one written or edited with AI help, and note the test in the workbook's change log.
Watch out
- Expected results must come from a separate calculation, not from the formula being tested.
- Test data should be invented, so nothing confidential reaches an AI tool.
Learn it properly
Official sources
- The AQuA Book: guidance on producing quality analysis for government · HM Treasury
- AI Playbook for the UK Government · UK Government
Facts last checked on 9 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.