Get a spreadsheet formula from a plain-English goal
code & data
// what it does
Describe what you want to compute and the cell ranges involved, name the app (Excel or Google Sheets), and ChatGPT writes the formula and explains each part. It handles the functions people forget the syntax of — XLOOKUP, SUMIFS, INDEX/MATCH, ARRAYFORMULA — and can adapt a formula when you describe how your columns are laid out.
// prompt
> Write an Excel formula that sums column C where column A equals "Paid" and column B is after 2025-01-01. Explain each argument.> In Google Sheets, I have names in A2:A100 and scores in B2:B100. Write a formula to return the name with the highest score.// gotcha
Excel and Google Sheets differ in function names, and some locales use a semicolon instead of a comma as the argument separator, so a formula for one can error in the other. State which app and, if a formula fails, tell ChatGPT your locale's list separator.