Explain the spreadsheet, not just the formula
Create and explain a formula with edge cases and a small test table.
For this spreadsheet task: [TASK], propose the formula for [EXCEL OR GOOGLE SHEETS]. Explain each part in plain language, list locale-specific separator issues, show five test rows including blanks and errors, and give a version that is easiest to maintain.
HOW TO USE IT
Make it specific.
Include the exact column names, sample rows and desired output. Test the formula on a copy before applying it broadly.
BEFORE YOU TRUST THE OUTPUT
Verify the result.
Check sources, live facts, calculations and sensitive information. A useful prompt improves the process; it does not guarantee a correct answer.