AssociationAI / AI Literacy

Live demo

Beginner

Try 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

RowMember typeRegistration date (MM/DD/YYYY)Kind of rowYour hand-worked answer

Result

RowFormula givesVerdictWhat 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.