Formula Test Case Builder
Create test data that proves a formula works.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Create test cases for a formula. App: [SPREADSHEET_APP]. The formula: [PASTE_FORMULA]. What it should do (rules in plain language): [RULES]. Typical inputs: [TYPICAL_INPUTS]. Return a test table: Case # | Description | Inputs | Expected result (calculated by hand, show the working) | Actual result (blank for me to fill in) | Pass or fail formula. Include categories of test: normal cases; boundaries (exactly on a threshold, zero, one less, one more); empty inputs; text where numbers are expected; negative numbers; very large and very small numbers; dates at month end, leap day, and year change; duplicates and ties; missing lookup values; trailing spaces and different cases; and cases designed to break assumptions (unsorted data, merged cells). Add: a layout with a "Tests" sheet that feeds inputs into the formula under test and compares to the expected column with a formula such as =IF(ABS(D2-E2)<0.0001, "PASS", "FAIL"); a summary count of passes; instructions for regression testing after changes; and guidance on documenting known limitations. Explain the expected results step by step for the five trickiest cases so I can verify them myself. Don't state expected results you cannot derive from the rules.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.