Live demo
BeginnerTry it: spreadsheet formula test lab
This is the working lab from our tutorial on testing an AI-written spreadsheet formula on rows where you already know the answer. Dana Okafor, meetings coordinator at the invented Lakeshore Society of Hospital Pharmacists (LSHP), needs a registration fee formula for the 2027 Annual Meeting. Both formulas below are written for this lab; neither is output from an AI tool.
The lab does not call any AI tool and does not open a spreadsheet. It works out each formula's result itself, in fixed rules that imitate how many spreadsheet apps behave. In this lab, as in many spreadsheet apps, a blank date counts as earlier than any real date.
The fee rule
Member $295. Nonmember $395. Members and Nonmembers who register on or before March 15, 2027 get $50 off. Student $95 flat, with no early-bird discount. A row with a blank member type or a blank registration date should return CHECK.
The formula
Changing the formula does not re-run anything. Press Check the formula to test it.
Your test rows
| Row | Member type | Registration date (MM/DD/YYYY) | Kind of row | Your hand-worked answer |
|---|
Result
| Row | Formula gives | Verdict | What it means |
|---|---|---|---|
| Press Check the formula. | |||
Kinds of row tested
Requiring all four kinds of row and the rule order are teaching choices for this lab, not a standard.
Not checked yet.
Plain-text record (select and copy it by hand)
Nothing checked yet.
This is a teaching example, not a case study. The society, people, fees and formulas in this lab are invented. Neither formula is output from an AI tool.