Text & chat prompt
Get the right Excel or Google Sheets formula
Get the right Excel or Google Sheets formula: a free, copy-paste prompt for ChatGPT, Gemini and Claude. Paste the prompt and replace each [BRACKETED] field with your own details.
The prompt
Write a formula for [EXCEL / GOOGLE SHEETS]. What I want: [DESCRIBE THE RESULT] My columns: [e.g. A = date, B = name, C = amount] Example rows and expected output: [EXAMPLES] Give the formula, explain each part, tell me where to paste it and give a simpler alternative if one exists. Mention any version limits.
Pro tip: Describe the sheet layout in words. It matters more than you think.
How to use this prompt
- Open ChatGPT and start a new chat.
- Paste the prompt.
- Replace each [BRACKETED] field with your real details and paste in your own text where asked.
- Reply with follow-ups such as "make it shorter" or "make it sound more like me".
Prompt at a glance
- Category
- Text & chat
- Works with
- ChatGPT · Gemini · Claude
- Length
- 56 words
- Fields to fill in
- EXCEL / GOOGLE SHEETS, DESCRIBE THE RESULT, EXAMPLES
- Last updated
Frequently asked questions
Which AI tools work with this prompt?
It is written for ChatGPT, Gemini and Claude. Paste it into your preferred tool and adjust the wording if the result is off.
What do I need to fill in?
Replace these fields before you send it: EXCEL / GOOGLE SHEETS, DESCRIBE THE RESULT, EXAMPLES. Each field shows an example in the prompt.
Should I paste private information into the prompt?
Only what the task needs. Remove names, contact details and other sensitive data before pasting a resume or document into any AI tool.