Task prompt · Data
Write an Excel or Google Sheets formula
by Agent Yard TeamThe formula you need, explained.
You'll attach
Text only
Works with
ChatGPT
Claude
Gemini
Grok
CopilotGrok BotUse cases
- The formula you need, explained.
- Reuse it as often as you like: fill in the blanks (excel or google sheets; what it should do; columns and example rows) with new details and copy again.
- With ChatGPT, Claude, Gemini and more, the AIs that support what this prompt needs.
Featured in: Best ChatGPT prompts for Excel and data, Best ChatGPT prompts for data analysis, Best AI prompts for spreadsheets and formulas.
How to use it
- Open chatgpt.com or claude.ai (or another AI listed here).
- Fill in the highlighted blanks ([EXCEL OR GOOGLE SHEETS], [WHAT IT SHOULD DO], [COLUMNS AND EXAMPLE ROWS]) below, or edit them after pasting.
- Copy the prompt, paste it into the chat and send.
Fill in the blanks (optional)
Prompt
Write a [EXCEL OR GOOGLE SHEETS] formula that [WHAT IT SHOULD DO]. My data: [COLUMNS AND EXAMPLE ROWS]. Explain how it works piece by piece, how to adapt it, and how it handles blanks and errors. If there's a simpler way (pivot table, filter), mention it.
One email a week
The Weekly is presented byyour brandSponsored · openThe best new prompts and personas, nothing else.