Skip to content

Stockertim Dictionary · Technology · Artificial intelligence

Boundary value

Also called boundary values, boundary value testing, edge case, threshold value

In short

An input that sits exactly on a threshold in a rule, such as a sale of exactly 200 where a bonus starts at 200, the point at which formulas most often go wrong.

  • Beginner
  • Concept
  • Checked

In detail

Rules with thresholds divide inputs into bands: below 200, from 200 to 399, 400 and above. Most values fall well inside a band, and almost any reasonable formula handles them correctly. The values at the edges are different. A sale of exactly 200, an age of exactly 18 or a date exactly 30 days after an invoice is where the difference between > and >=, or between a strictly earlier date and the same day, decides the answer.

Software testers have long used boundary value analysis for this reason: for every threshold they test the value on it and the values just below and just above. In a spreadsheet that means 199, 200 and 201 for a 200 threshold, or 199.99 and 200.00 where pennies matter. Each band also gets one ordinary value, and the lowest and highest possible inputs are tried.

Rule wording creates many boundary errors before any formula is written. "Over 200", "200 or more", "from 200" and "above 200" mean different things at exactly 200, and policies are not always precise. Settling the wording first, in writing, makes the test cases obvious. Rounding adds another trap: a value shown as 200.00 may really be 199.996, which a >=200 test rejects.

AI-drafted formulas make boundary testing more important. A model can write a formula that matches the general idea of the rule but uses a strict comparison at one edge, and nothing in its output hints at the slip. Real data may contain no boundary values for months, so the error shows up only later, in someone's pay or bill.

Worked example

A call centre in Belfast pays a bonus of 50 to agents with a quality score of 90 or more. The drafted formula is =IF(B2>90,50,0).

  1. Score 95: inside the bonus band, both > and >= give 50
  2. Score 90: the rule gives 50, but the formula gives 0
  3. Score 89: below the band, both give 0

Only the boundary value of 90 reveals that > should be >=.

In practice

Analysts list every threshold in a rule and test each at, just below and just above it before using a formula, and policy writers state thresholds with words such as "or more" to remove doubt.

Watch out

  • Displayed rounding can hide values just under a threshold.
  • Agree the wording of the rule at the boundary before testing the formula.

Learn it properly

Official sources

Facts last checked on 9 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English