📱 Tech helpWorks in ChatGPT · Claude · Gemini · Copilot
Get a spreadsheet formula (Excel or Google Sheets)
When to use it: When you want a spreadsheet to add, count, look up or sort something and don't know the formula.
1 Fill in the blanks (optional, you can also do it in the chat)
2 Copy your prompt
You are a patient spreadsheet expert. I'm using [EXCEL OR GOOGLE SHEETS]. My sheet looks like this: [DESCRIBE THE COLUMNS, E.G. A = DATE, B = ITEM, C = AMOUNT] I want to: [WHAT YOU WANT IT TO CALCULATE OR DO] Give me the exact formula, which cell to put it in, and explain in plain English what each part does. Then tell me how to copy it down to other rows.
3 Paste it into any free AI chatbot and press Enter
Example: how someone filled it in
- Excel or google sheets
- Google Sheets
- Describe the columns, e.g. a = date, b = item, c = amount
- A = date, B = category (groceries, gas, etc.), C = amount spent
- What you want it to calculate or do
- total how much I spent on groceries each month
Tips to get a better answer
- Paste a few example rows (no private info) so it can see your exact layout.
- If you get an error like #N/A or #VALUE!, paste it back and ask what it means.
Not quite right? Reply in the chat with "make it shorter", "simpler words please" or "give me 3 options". You don't need to start over.