ChatGPT prompt to write an Excel formula
No need to know the functions: describe your columns and what you want to calculate, and the AI writes the Excel or Google Sheets formula, explains it and tells you where to paste it.
Your prompt
🔒 The fields stay in your browser. The prompt is only sent to the AI service you choose to open.
How do I ask ChatGPT for an Excel formula?
State your software and its language, describe your table's columns with example values, then the result you want. Ask for the formula ready to paste, the cell to put it in and a step-by-step explanation. The free Lunyce prompt includes these instructions and matches your Excel version.
How to use it
- Enter your software and its language, then describe the columns in your table.
- Explain in your own words the calculation you want, then copy or open the prompt.
- Paste the formula into the cell indicated and check the result on a few rows worked out by hand.
Tips for better results
- Is your table in a PDF? Convert it first with the Lunyce "PDF to Excel" tool.
- Do not paste real personal data: replace names with "Customer 1", "Customer 2".
- If the formula returns an error, paste it back into the conversation with the message shown.
Does ChatGPT write Excel formulas for any language version?
Yes, if you say which one, as this prompt does. English Excel uses names like SUMIFS and XLOOKUP with commas, while many other language versions use translated function names and semicolons: a formula in the wrong format returns an error.